Select worksheet tabs according to value of cell in another worksheet

[JB1970]

Hi

I have a workbook I use that has multiple sheets. Depending on the circumstances, I need to print different sheets each time. Currently to group the sheets I'm having to hold the ctrl key & select/deselect each sheet that I want to group manually. With 25 sheets & counting in the workbook, this is a pain.

What I'd like to do is have an additional sheet used as an index, with a column listing all of the individual sheets & have it set up so that if i enter a value in the cell adjacent, the appropriate worksheet/tab is added to the group. Worksheet 1 A1 - A25 would have the title of each worksheet & if I want a sheet to be selected, I enter a value in B1 to B25. For instance entering "Y" in B3, B4, B8 & B18 to B20 would select the corresponding 6 tabs/sheets so that when I hit print (to pdf) I'll have a single pdf file containing those sheets.

Any assistance appreciated.

John

[:) Sixthsense :)]

Please attach a sample workbook with enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Note: Please don't attach documents containing confidential data like (address, telephone, ID#s, etc.).

[JB1970]

Sixthsense

Sorry can't upload a mock up of what I want, but should be fairly clear what I'm trying to achieve.

Example - workbook with 10 sheets. Sheet 1 is an index page & sheets 2 - 10 are the pages I may or may not want to print. On sheet 1 (my index) I will populate cells A1 - A9 to contain the names of sheets 2 - 10. I want to be able to open the book on sheet 1 & enter a value in B1 - B9 (could be any value, a Y or YES or 1 for instance). If I've entered that value in B1, B2 & B3, the sheets referred to in A1, A2 & A3 will be grouped, therefore when I print, those three sheets only will be printed.

Regards

John

[:) Sixthsense :)]

Try the below code…

Please Login or Register  to view this content.