So I've got a main excel spreadsheet and I have a dropdown menu for "customers" I have a list of customers,addresses,etc in another spreadsheet, and I would like to have a dropdown menu that you can select the customers from, which will then populate other boxes in my main spreadsheet with their addresses, etc. The only reason I keep the customer list in another spreadsheet is that it will create bigger save files for each time I save the main file. I can provide screenshots of what I already have, everything else is already set up, I just need to know how to reference the other spreadsheet. My knowledge of VBA is negligible at best, so any and all help would be appreciated.

Thanks a lot.