Creating drop-down list from worksheet in another workbook

J0R0

New Member
Joined
Jul 2, 2020
Messages
1
Office Version
  1. 2010
  2. 2007
Platform
  1. Windows
Hi all,

I am trying to accomplish a small task and I cannot find a suitable answer from the web search sources I have so far found.

My scenario is that I have an excel form with a field called "Names" that is a drop-down list. This drop-down list is populated from data on another worksheet (called "Names Lookup") within the same workbook. This is working successfully. The population takes place using VBA code.

I want to move the "Names Lookup" worksheet to a new workbook and populate the "Names" field from this other worksheet in the new workbook.

Is it possible to achieve this by directly accessing the data in the "Names Lookup" worksheet in the other workbook and populate the "Names" field accordingly?

Many thanks for any responses.
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Watch MrExcel Video

Forum statistics

Threads
1,114,002
Messages
5,545,439
Members
410,684
Latest member
LakTik
Top