Here is a good post that accurately resets what Excel parses on when you paste text. I have known for a long long time, that the LAST text-to-columns settings is what is used when one pastes data into excel, but I thought I would see (I finally snapped for the last time) what other people did. Well, it is a macro of what I always do by hand – a fake text to columns that sets things in prep for the real one. My issues is that I have all sorts of macros that could set this here or there depending on the last one I ran. Thanks for the post!

http://spreadsheetpage.com/index.php/tip/clearing_the_text_to_columns_parameters/

Here is a good article with many links and debates. I have used the “accepted” answer and gotten 95% accurate results – so why not 100%? I have not solved that one. I am trying the 2nd answer which in the efficiency graph gives better results.

http://stackoverflow.com/questions/18932/how-can-i-remove-duplicate-rows

Here is a nugget – a friend of mine made a dashboard with no VBA where the user IN EXCEL – pulls down a dynamic value to … lets say “may 2015” and the charts etc. update. One could do this in VBA, but, you don’t have to. I thought it was worth saving/sharing the link.

I have a client who wants some PDFs messed with. To do so, layers need to be split and recompiled. Here are links that will help me

1. decide which SDK to use
2. how to … well … do it.

• A good discussion of pdf libraries
• layers or content streams
• extract layers
• http://www.soft-xpansion.eu/files/pdflib/PDF%20Xpansion%20SDK%20Guide.pdf
• foxxit, sdk documentation
• PDFtron
• pdf creation
• opensource
• separate into text and other
• a good article steering the way
• pdfkit – a nodejs sdk to MAKE pdfs
• pdffill, pdf.wondershare (pdffill object remover)