Hey all,
I'm looking for some help with a macro that will create a new tab called "Summary" then copy a range of A1:B10 from all available tabs and place this information on the summary tab in the landscape orientation (meaning a1:b10, c1:d10, e1:f10, etc). The number of available tabs may be different on the various spreadsheets I run the macro on. Thanks for your help.
I'm looking for some help with a macro that will create a new tab called "Summary" then copy a range of A1:B10 from all available tabs and place this information on the summary tab in the landscape orientation (meaning a1:b10, c1:d10, e1:f10, etc). The number of available tabs may be different on the various spreadsheets I run the macro on. Thanks for your help.
