Hello,
I am trying to build an invoice system for my office where by they will
1) Open a template invoice file
2) Fill out the details in 7 specific cells. Invoice No (b1), No. of Cartons(c5), Date (g1), Document no (c3), Shipper Name(a10), Order No(b2), and Order Value(g12).
3) When they press a certain button on the sheet, I want all of the above information flow into a separate worksheet with column headings of the same 7 items listed above.
4) I also want a save as window to pop-up so that they can save this invoice under a different name, as to not affect the template invoice file.
Any advice?
I know almost 0 about VBA, so code would be very much appreciated.
Thanks
Bookmarks