Need help with printing worksheets via a control page

[Matthew55]

Hello. I'm quite new to VBA and know just enough to be dangerous. My goal is to be able to use a "Print Control" worksheet to be able to select which pages to print. Column 1 is either "Yes" or "No". Column 2 is the name of the Worksheet. I think I should be able to do this as a loop with offset, but I'm not that advanced. Further, I will have a participant statement in which the participant changes based on a cell in the "Individual" worksheet which triggers an indirect statement to populate the statement them print the statement, and so forth for the selected participants.

I think based on this and by looking at what I have done so far, what I'm after will be clear. Please see attached.

Any help is greatly appreciated. I attached what I have thus far. THX.

[skywriter]

You can try this to get you started.

Please Login or Register  to view this content.

I don't know what you are doing with this.

Further, I will have a participant statement in which the participant changes based on a cell in the "Individual" worksheet which triggers an indirect statement to populate the statement them print the statement, and so forth for the selected participants.

[Matthew55]

What I'm trying to accomplish is this: For the first 10 rows in the "Print Control" worksheet, where the value "YES" exists in column A, print the worksheet which is named in column B. For the remaining rows (11-60), where the value "Yes" exists in column A, populate cell B1 in the "Individual" worksheet with the value in column C of that row, then print the "Individual" worksheet (the data in the "Individual" worksheet will be populated with specific individual data based on the value put in cell B1 via indirect references to another worksheet which was not included for privacy purposes). Then move to the next "Yes" in column A and repeat (loop). I modified my example to have "Individual" as the value in cells B11:B60 to correspond to the worksheet of the same name. I hope this provides clarity.

[Matthew55]

Hello...

Can anyone assist with the above?

Much appreciated.