Hi all,
I know enough about Excel & VBA to be dangerous so I'm looking for a bit of help. I have a workbook that includes sheets populated with a data list (tournaments & dates and hotels with complete address info) I have created a Userform that will be used to generate invoices. My plan is to use combobox dropdowns so that I can select from the events list and the hotel list to populate an invoice sheet that is on a separate tab.
How can I pull the data from that sheet to the dropdown list (I don't want to hard code it as the list will be added to over time). Do I just name the range of hotels and have that dropdown use that name to populate the list or is there another way to do this?
Thanks for the help.
Bookmarks