I have two sheets in a workbook
sheet 1 (a finished polished invoice form)
sheet 2.( a list 1-20 to enter all info)
I enter all of my information on sheet 2 and it populates in sheet one on a designed form.
I need a macro with a button that executes it that will be at the bottom of sheet 2. So once we fill everything in it will print sheet 1, then save sheet 1 under the customer name which is in cell b5 then reset the forms for next entry.
Any ideas?
sheet 1 (a finished polished invoice form)
sheet 2.( a list 1-20 to enter all info)
I enter all of my information on sheet 2 and it populates in sheet one on a designed form.
I need a macro with a button that executes it that will be at the bottom of sheet 2. So once we fill everything in it will print sheet 1, then save sheet 1 under the customer name which is in cell b5 then reset the forms for next entry.
Any ideas?
