I am wondering if writing a macro is a possibility for what I want to accomplish in excel 2003 and/or excel 2007?
Basically I receive a workbook from my company's main customer to extract data from one of the tabs and load the data into sql server. I am told by my company that the way I obtain the data from the customer is going to stay the way it is and I need to work with the data in that format.
Basically the data comes in one of the middle tabs of the workbook. When I get to the tab I need to work with, I manually have to do the following:
1. unhide some columns,
2. remove links to external files
3. and possibly change the column headers.
Most of the time I just copy the data I need to a new worksheet in a new workbook.


Thus can I accomplish the following my goal using a macro? If so, can you tell me or point me to a reference that will show me how to use a macro to accomplish this goal?
If using a macro does not work, can you tell me if I can accomplish my goal using VBA or some other means? If so, can you tell me and/or point me to a reference that will show me how to accomplish my goal?

Hi jassie,

All of what you've described is possible, but you haven't given enough details for anyone to suggest any code for it. FWIW, using a macro (and even without one), you can copy the contents of hidden columns/rows without unhiding them.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]