I need some help writing a macro for printing.
My excel file for generating a Purchase Order is like this:
Sheet 1: User fills in all the data. Also has a command button for print.
Sheet 2: (Hidden) Takes data from sheet 1 and formatted for printing (zoom, print areas, margins etc are...