I have attached a screenshot of a listbox i have created. I have populated the data, now i need code that allows the user to click on the book and click on then a book home and press "Enter Map"
On pressing "Enter Map" i want the book and book home to be sent to a workbook called ("Match.xl") sheet is called "Mapping Table" and the range it needs to be sent is K2:L2 to how many rows needed
So i need the user to press ctrl and select the book and book home and then the data to be sent
I am open to sending this data differently if this is not the most efficient way of sending the data