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?