For next sheet +1

[cooket4]

Hi

I have one big sheet, one summary page, which is to be a summary journal of all the other area managers journals

I have basic bits done but I am stuck flicking from the managers journal, then pasting it to the summary, then going to the next managers journal sheet.

the summary sheet is on sheet(3) or "Summary Journal", the managers journals are from sheets(5) and above.

The amount of managers change every month and I have to sumif their data, which I have already done.

I need to flick from sheets(5) to the "Summary Journal", do my stuff, then to sheets(6), then to the "Summary Journal", then Sheets(7) and so on

Im assuming I need to, when on Sheets(5) I need to dim the sh = sh+1 or something like that

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[cooket4]

Thats works brilliant, I'll remember this usefull function

thank you

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.