Combine Subtotal Macro

[Harlequin]

Hello

I have the following code to subtotal column B (Which are dates) for a location, in a worksheet called “IRDUB52”.

However, I have 3 other new locations, or worksheets now coming on (“IRDUB55”, “IRDUB60”, & “IRDUB65”).

Rather than have a separate macro for each one, by just changing the worksheet name, can all four of these locations / worksheets, be combined into the macro below so as I only have to press one macro, & not 4 individual macros?

Please Login or Register  to view this content.

Cheers

[JustinBram]

use this in the same workbook but make sure you have four sheets with your names “IRDUB52”, "IRDUB55”, “IRDUB60” and “IRDUB65” this will only work with each sheet being in the same format.

Please Login or Register  to view this content.

lemme know how you get on

[JustinBram]

format wasn't the right word, layout is the right word

[Harlequin]

Sorry, that didn't work.

I attach a copy of the workbook with your code in it.

Cheers

[Harlequin]

Sorry.

I attach it now.

[Leith Ross]

Hello Harlequin,

Since the formatting, and data locations are the same on these sheets, the macro can be easily be modified to take the Worksheet name as an argument. Another macro can then call all 4 sheets using a command button.

Revised Macro

Please Login or Register  to view this content.

Macro to Call Multiple Worksheets

Please Login or Register  to view this content.

SIncerely,
Leith Ross

[Harlequin]

Sorry Leith.

I tried to use that but it didn't work. Can you insert it into that spreadsheet I attached?

Many thanks

[Leith Ross]

Hello Harlequin,

The macros have been installed in the attached workbook.

Sincerely,
Leith Ross

[Harlequin]

Leith.

You're a genius.

Many Thanks