I have an Excel template workbook that has 20 worksheets. The sheets represent different machines. When a customer orders a machine the appropriate info is entered into the template. Not all the sheets are used for any one customer.
Is there a way to create a macro that will only print the sheets with data entered on them and possible number them at the bottom? Currently, we go to each worksheet in the workbook and print it as needed. The final printed version has no numbers as they are all from different worksheets.
Deb
Bookmarks