printing pages from sheet based on cell value...

[RobbieC255]

Hi there, I have a sheet (Labels) within my workbook which I have designed to print out 'labels' based on data inputted from another sheet (Calculations). All of the labels fit within their print area (page1, page2, page3... page35) and this all works well

However, I don't want all the labels to print each time, only those which correspond with the cell which is set to TRUE (Calculations sheet, column I, row 1-35 to correspond with each label)

I've been scratching my head with this all morning...

Ultimately, I want to build a purpose 'PRINT LABELS' button on the worksheet which will handle this, but I'll be quite happy to get the basics done first...

If you can point me in the right direction, I'd be very grateful

Thanks

Rob

[zbor]

Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-prog...ell-value.html

Thread Closed.