Printing Multiple Worksheets

[Cynops]

Hi!

I am working through two worksheets.
sheet one is a simple form of which only one cell is changed and unique, which I want to print.
sheet two is a huge list of data of which does included the one unique reference which relates to sheet one.

I will be adding 50-100 rows to sheet two weekly, thus giving me 50-100 different forms (Sheet one)

Is there a way to automatically do this? as I am currently copying and pasting 50-100 times and printing?

Sorry I am probably making this sound a lot more complicated than it actually is?

#PASSWORD: bridal

[bulina2k]

Hi there!
Make a button somewhere on Sheet "REPORT " and put this code under:

Please Login or Register  to view this content.

The code works like this: because there is no criteria of sort, you'll have to select one or multiple items from column A in sheet REPORT and press the newly created button. Each item from selection will replace the ID in sheet FORM cell C7 and will print the form.

[Greg M]

Hi there,

See if the attached workbook does what you need. It uses the following code:

Please Login or Register  to view this content.

The highlighted values can be changed to suit your own requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

[bulina2k]

OK, new version with week-number sorting. I have added another button for week criteria. The selection based print remains the same.

Please Login or Register  to view this content.

[Cynops]

This works perfectly!

Thank you very much!