Printing Groups of Worksheets

[Paul Sheppard]

Hi I am using excel 2000

I have a workbook with 78 worksheets each representing a store, the stores are split between 10 Area Managers

I want to be able to print the worksheets for each area manager, I am currently using the following code

Please Login or Register  to view this content.

This is repeated for each of the Area Managers

Is it possible to write code to print the stores of each AM from a list, where the AM name is in column A and the store names are in column B

This would save me updating 10 lots of code every time the Area Manager areas change

Thanks

Paul

[shg]

If the area managers are in col A and their stores in col B (both starting in Row 2, no blanks), then just sort by col A and print the sheets in the order they appear in col B:

Please Login or Register  to view this content.

[Paul Sheppard]

If the area managers are in col A and their stores in col B (both starting in Row 2, no blanks), then just sort by col A and print the sheets in the order they appear in col B:

Please Login or Register  to view this content.

This prints all the worksheets, I need to be able to select to print an individual area

[shg]

Change the line to,

Please Login or Register  to view this content.

[Paul Sheppard]

Change the line to,

Please Login or Register  to view this content.

I now have this code

Please Login or Register  to view this content.

This works only if I have the workbook open to the worksheet with the list, can it work if the worksheet with the list is hidden?

Thanks for all your help so far

[shg]

Yes, but you have to qualify the range references:

Please Login or Register  to view this content.

[Paul Sheppard]

Yes, but you have to qualify the range references:

Please Login or Register  to view this content.

Hi shg

That's great thanks for your time and patience

Paul

[shg]

You're welcome, Paul, glad it worked for you.

[Paul Sheppard]

wrong thread