Hello all. I am new to VB and am wondering how to do this.
I have one workbook (Quote) to create a customer quote when a sale occurs and additional workbook (Booking) for a list of all of the booked orders.
I am wondering if there is a way to create a button that when clicked automatically adds the order number and quantity into the booking list in the other excel sheet.
Here is an example of what I want to pull from the quote sheet:
quote_example.PNG
And here is an example of the booking list:
book_example.PNG
I want the information from the quote sheet to automatically update the booking list when the button is clicked. I have no idea what I am doing...any help is greatly appreciated!
Bookmarks