Running Macro on multiple sheets

Hi, VKS,

regarding the first question:

Please Login or Register  to view this content.

Second question:
have you tried recording a macro during that consolidating as a start?

Ciao,
Holger

Hi,

We'd need to see the workbook in question before being able to advise with any specific code. Upload the workbook along with some notes which clearly explain which sheets should be processed by your clean up macro, which sheets should be processed by the new macro and what the consolidated sheet should look like.

Hi,

Try:

Please Login or Register  to view this content.

Hi,
Difficult to say without seeing the real file.

However it's important not to confuse the sheet TAB name and the name that VBA knows the sheet by. The two can be completely different. When a new workbook is created then they start out the same. However and as in your case, the sheet tab names have been changed to something more meaningful. But just because the Tab name changes doesn't mean the VB name changes, it doesn't. That will only change if you go to the VB environment and change it. In your example case the Tab called "Consolidated Sheet" has the VB code name of 'Sheet1'.

I suggest you check your real file and see what the code name is for the Consolidated sheet and change the macro I gave you accordingly.

Hi VKS,

Your worksheets are indexed and you can access them without using their names.

Worksheets(1) is the first one and looks like you are using it for the consolidation sheet. Worksheets.Count is the last worksheet.

Instead of using the code of "For Each WS", I like to use the For Next type of code...

Please Login or Register  to view this content.

I hope using worksheet indexes helps instead of using the For Each construct.