Hi guys
I have a 'Data sheet', where I keep tracks of all items and quantities. I have another sheet 'Print sheet', where I design the layout to print out the items as an invoice. Please see the photo below. The problem I am facing is I have to keep the company's info in every invoices and only change the data according to the order number.
Annotation 2019-12-12 085130.png
Therefore, is there any way that I print out the first invoice then the excel will take data from the next order number from the 'Data sheet' and insert it in the print sheet so I can the second invoice and so on.
Or the purpose is I can print out all the invoices with their information without having to copy all the company info again and again.
Thanks guys
Bookmarks