Hi

Can anyone help me regarding a Macro needed for Excel.

I have a sheet "Sheet1" within a work book that users enter data. It has been formatted to 40 pages long with totals on each page.

I only want to print each page if there is an amount on each page for e.g

If cell S27 > 0.00 then print 1 page
If cell S54 > 0.00 then print 2 pages

and so on up to 40 pages.

Is this possible and can someone please help with a macro to do this?

many thanks