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

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Watch MrExcel Video

Forum statistics

Threads
1,112,784
Messages
5,542,500
Members
410,559
Latest member
jordansmith6532
Top