help_questions
Board Regular
- Joined
- Aug 22, 2005
- Messages
- 215
I have a report that I am trying to automate.
THis report will have 15-20 different tabs/worksheets. Each worksheet will be named will be titled for each segment.
On the Data worksheet, I will have a data report, reflecting the results from the day before. There will a row of results for each segment. Column A will identify each of the segments, with it results going across the row.
I need a macro to search through the segments in column A, and each segment, go to the respective worksheet, and insert the corresponding row from the data worksheet. Then, after doing this for all segments in column A (populated fields), the macro is to save and close.
Can this be done?
THis report will have 15-20 different tabs/worksheets. Each worksheet will be named will be titled for each segment.
On the Data worksheet, I will have a data report, reflecting the results from the day before. There will a row of results for each segment. Column A will identify each of the segments, with it results going across the row.
I need a macro to search through the segments in column A, and each segment, go to the respective worksheet, and insert the corresponding row from the data worksheet. Then, after doing this for all segments in column A (populated fields), the macro is to save and close.
Can this be done?