Hi all,
I've found so many macros that do this in various ways, that I feel embarrassed asking this. I'm quite new to VBA programming (programming in general), but I think I've got a bit of a handle on it.
My problem.
I have workbooks with 3 constant worksheet names and between 5-20 other worksheets of random alpha-numerical names (I'll refer to these as the non-constant worksheets). The data on all the non-constant worksheets is formatted in the same way.
I want to copy the value of the same cell (C6) on all non-constant worksheets, along with the sheet name, to a new summary sheet (starting in row2).
The worksheets I *do not* want to copy data from are named "all", "Generation_Summary" and "Inverse_Generation_Summary".
My summary sheet is called "General_Summary" and I make it using:
I want to iteratively go through the rest of the workbook, and as it iterates:Please Login or Register to view this content.
copy the name of each sheet to "General_Summary" Column A, and
copy the value (its calculated from a formula) out of Range C6 on the same sheet to "General_Summary" Column B, resulting in something like:
In the iterative loop I want to *skip over* the worksheets named "all", "Generation_Summary" and "Inverse_Generation_Summary".Please Login or Register to view this content.
thanks kindly for any help.
best regards.
Bookmarks