Drop down Lists from a different workbook
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 |
All times are GMT +1. The time now is 02:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com