-
Solved: Data from multiple sheets into one sheet?
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules