Drop down Lists from a different workbook

J

jzambran

I am trying o set up a 'Database' workbook spreadsheet which contains names,
countries, etc. which will validate entries on a number of separate workbook
(Forms).
This 'Database' workbook will be updated constantly-ish (by me) and need to
feed into the drop-down menus of the other workbooks (to be used by a number
of people on a read-only basis). All these files will be located in the same
folder.

The reason why I need this 'database' it is because it contains information
that more than one type of workbooks (forms) will be asking for and I do not
want to set up a range within each 'form' with validation data as it means I
will have to update every single 'form' constantly (over 15).

I need help on deciding what to use (and how to use it), as I cannot set up
'names' from other workbooks and data validation from other workbooks do not
seem to work either

Thanks so much in advance for your help.

Juan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

problem with drop down lists 1
create drop down list from different workbook 2
Updating a master workbook with 80 workbooks 1
Macro to push data to another workbook 0
Named Range From One Workbook Used in Validation Drop Down in 2nd Workbook 1
Drop down lists that reference another workbook 5
drop down list showing dates instead of numbers 2
Data Validation for list in a different workbook 2

Top