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?
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?
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.