How to load data from seperate workbooks with drop down function


So I have multiple workbooks with data within them and I want to create a seperate workbook with tables that I want to have those tables populate with data from other work books via some form of drop down function. Is there anyone that can help me?



Post a copy of the destination workbook you intend to create so that the task becomes discernible.
Variatus (rep: 4729) Jul 18, '19 at 10:35 pm
Add to Discussion



You basically just use Data Validation (Alt + D + L) to create a List and make it an in-cell drop down.

You might not be able to make the drop down directly point to the other worksheet, I don't remember and can't test right now, but you could surely have a worksheet that has the purpose of getting data from the other worksheet, maybe just via cell references, and then reference that data using a Named Range and then reference that Named Range in the Data Validation list.

Basically, this is not the most simple task and if your list doesn't change often/ever, just copy it from the other workbook into your current one.


Actually, as I re-read your question, I feel that I originally mis-read it. If you want a VBA function that copies data when you make a selection in-cell, then yes, that is quite doable, just edit your question and include more detail about what you want to do - you will make the macro run via a worksheet_change event.


Answer the Question

You must create an account to use the forum. Create an Account or Login