jolivanes
07-02-2008, 05:05 PM
In a workbook with multiple sheets, I want to copy Column B and D from sheet3 to a new sheet (named Total).
Then I want to find each string in Column B in sheet3 in subsequent sheets and add each value
to the right of the found string and put the total of these values to the right of the same
string in the newly created sheet Total. Not all strings from sheet3 are in every sheet though and both
sheet3 and the other sheets have spaces between the entries.
I have individual sheet copying working with an adapted macro from xld at:
http://www.vbaexpress.com/forum/showthread.php?t=20185
This works like a beauty.
A toned down workbook is attached as an example. I hope this makes it clear.
The full workbook is too big to attach.
Hope someone can steer me in the right direction.
Thanks
John
Then I want to find each string in Column B in sheet3 in subsequent sheets and add each value
to the right of the found string and put the total of these values to the right of the same
string in the newly created sheet Total. Not all strings from sheet3 are in every sheet though and both
sheet3 and the other sheets have spaces between the entries.
I have individual sheet copying working with an adapted macro from xld at:
http://www.vbaexpress.com/forum/showthread.php?t=20185
This works like a beauty.
A toned down workbook is attached as an example. I hope this makes it clear.
The full workbook is too big to attach.
Hope someone can steer me in the right direction.
Thanks
John