jkrzwyld_58
New member
- Feb 12, 2009
- 1
- 0
- 1
My issue is I have a report which generates multiple tabs (Number of tabs change from report run to report run). Each tab has varying number of rows of data. My question is a 2 part question.
1) Does any one have a macro that grabs data from a varying number of tabs, each with a varying number of rows of data and merge it to a single sheet.
2) Sometimes I just need a summary sheet which lists each tab name with the sheets subtotal. Does anyone have a macro that will copy each tab name into a list and references a subtotal on each tab.
Thank you.
1) Does any one have a macro that grabs data from a varying number of tabs, each with a varying number of rows of data and merge it to a single sheet.
2) Sometimes I just need a summary sheet which lists each tab name with the sheets subtotal. Does anyone have a macro that will copy each tab name into a list and references a subtotal on each tab.
Thank you.