I have an Excel spreadsheet that only uses about 7 columns of data but I need to extract these 7 columns from a CSV file that has about 50 columns. Do I need to write a macro to extract these 7 columns and then place them in the correct order? It is something I'll need to do at least once per day. Any help would be greatly appreciated.
You may want to ask this question on stackoverflow, I'm sure you will get lots of insightful responses. My suggestion however is keep both sources, your master (currently xls) and your source (csv) in csv format. This way you can simply write a script to extract those 7 columns and append them to your master source.