Hi,
I have a workbook with 15 sheets. 12 contain information about part types and are identical in layout. They contain formulas which pull data from the other 3 sheets. In each of the part type sheets, a list is created according to certain criteria.
In a separate Summary sheet, I would like to create a compilation of these part type lists. It would copy all rows containing data from Sheet 1, and paste it in the Summary sheet in A1 and on. Then it would copy all rows containing data from Sheet 2 and paste it in the next blank row in the Summary sheet, etc. I'm assuming that I will have to use some sort of VBA to jump between sheets, but I'm having a hard time writing it properly.
Would anyone be able to help me out? Thank you!!
Bookmarks