eversharp
08-12-2012, 08:39 AM
I have a workbook with over 100 tabs... the tabs are identical other than the date and the data within... for example there is a sheet/tab for 2-2-2012, another for 2-3-2012, and so forth.
I want to run a macro that would go through each sheet and copy specific cells to a new "summary sheet"
The data in each individual sheet looks like this (in columns D, E, and F):
DATE TYPE AMOUNT
2-1-2012 X $2,492
2-1-2012 Y $4,102
Then the next sheet would look the same:
DATE TYPE AMOUNT
2-2-2012 X $1,494
2-2-2012 Y $3,104
I want to run a macro to produce a summary sheet that looks like this:
2-1-2012 X $2,492
2-1-2012 Y $4,102
2-2-2012 X $1,494
2-2-2012 Y $3,104
and so on
Any help with syntax would be great. I tried to record a macro but couldn't get it to work for more than one sheet.
I think my psuedo-code would be something like:
for each sheet in workbook,
copy cells D1, D2, E1, E2, F1, F2
to the next available row in a sheet called 'SUMMARY'
Appreciate any insight
I want to run a macro that would go through each sheet and copy specific cells to a new "summary sheet"
The data in each individual sheet looks like this (in columns D, E, and F):
DATE TYPE AMOUNT
2-1-2012 X $2,492
2-1-2012 Y $4,102
Then the next sheet would look the same:
DATE TYPE AMOUNT
2-2-2012 X $1,494
2-2-2012 Y $3,104
I want to run a macro to produce a summary sheet that looks like this:
2-1-2012 X $2,492
2-1-2012 Y $4,102
2-2-2012 X $1,494
2-2-2012 Y $3,104
and so on
Any help with syntax would be great. I tried to record a macro but couldn't get it to work for more than one sheet.
I think my psuedo-code would be something like:
for each sheet in workbook,
copy cells D1, D2, E1, E2, F1, F2
to the next available row in a sheet called 'SUMMARY'
Appreciate any insight