I have a workbook I maintain with MANY worksheets showing price lists for
different accounts. Each worksheet has several pages. I want the footer to
print the page # for the worksheet, not the page # of the workbook. In other
words, pages 1,2,3 on worksheet 2 should also read 1,2,3 not 4,5,6. When I
print each sheet individually the page #s are correct but when we print the
entire workbook, it shows the wrong #s. Is there an Easy way of doing this?
Other people in the office are doing the printing (the easy way) and sending
out mailings with bad page #s. Help?