I am looking to create a button in a row of data that i can click and will use the data in that row to auto fill an invoice which is a separate worksheet.
I have a worksheet for all my customers. In that row is their Customer Number, Name, Address, Phone and Email. I want to be able to hit one button that sends all that info into specific cells of another worksheet when I am making the invoice for them instead of retyping it every time. Any help would be greatly appreciated.
I have a worksheet for all my customers. In that row is their Customer Number, Name, Address, Phone and Email. I want to be able to hit one button that sends all that info into specific cells of another worksheet when I am making the invoice for them instead of retyping it every time. Any help would be greatly appreciated.