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
Bookmarks