Write a Macro to print in Excel. Here is exactly what I need:
Right now I type "1" in a cell and then that customers information comes up on an invoice sheet I created. I then hit print. And then I move on to customer "2", hit print, and so on. I would like this automated so that it just prints until the end of the customers list and then stops.
Also, there are some customer accounts that have a zero balance and do not need to be printed. If a cell = 0, then that invoice is not printed and the Macro moves to the next customer number. But again, when the last customer number comes up, the macro stops printing.
I have 2 workbooks that need the same exact thing, described above. And then 2 more that need just basic printing Macro, 1,2,3,4,5, and so on until the end is reached.
I attached 2 example files.
Please ask any questions!