I have a workbook where 1 sheet has a list of numbers starting at b12 on down (list gets bigger and smaller) and another sheet has a bunch of lookup formulas on it. I key in the numbers 1 by 1 from the 1st sheet into cell N1 on the sheet with the formulas. The formulas then input a bunch of info creating an invoice and I print the page. Then key the next number and so on.
Is it possible to have a macro enter the numbers for me 1 by 1 printing each page after it enters?? This would be a tremendous time saver.
Thank you very much for your time and help.
Bookmarks