I do not have a file to attach as an example at this time so I will do my best to explain. In Excel 2003, I have a workbook which will contain an unknown number of sheets. I need the macro to go through each sheet and pull data to a summary sheet. There could be an unknown number of sheets so it will need to look to see how many to end.
Summary sheet will always be the first sheet.
The column headings on each sheet match the summary sheet except for the Totals column of my summary sheet (this may not matter)
Column A ="Project" Column B="Name" Column C="Number" Column D=AccountNumber", Column E="Totals" on my Summary Sheet and its contents are most of the time in cell F24
Cell A2 on each sheet will contain a value that needs pulled to Cell A2 on the Summary Sheet
Cell B2 on each sheet will contain a value that needs pulled to Cell B2 on the Summary Sheet
Cell C2 on each sheet will contain a value that needs pulled to Cell C2 on the Summary Sheet
Cell D2 on each sheet will contain a value that needs pulled to Cell D2 on the Summary Sheet
Cell F24 will be my Totals column on the worksheets and will need pulled to Cell E2 on the Summary Sheet
Please help.
Bookmarks