Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

How to load data from seperate workbooks with drop down function

0

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?

Answer
Discuss

Discussion

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

Answers

0

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.

Discuss


Answer the Question

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