Drop Down Lists Referencing Another Workbook

[VersatileSZ]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

So I am making a Budgeting Data Base for my company and want to have one workbook dedicated to Items and the Budget and the other Workbook dedicated to the actual Items in the budget. I know this is extremely easy in one workbook all you have to do is reference another sheet but I want my Budget Database to be in a separate workbook. So is it possible for a drop down menu in a cell to reference a list in another workbook?

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

So I am making a Budgeting Data Base for my company and want to have one
workbook dedicated to Items and the Budget and the other Workbook dedicated
to the actual Items in the budget. I know this is extremely easy in one
workbook all you have to do is reference another sheet but I want my Budget
Database to be in a separate workbook. So is it possible for a drop down menu
in a cell to reference a list in another workbook?

Not directly, but if you, say on a hidden sheet, had a range that
referenced the other workbook's range, you could use that instead. For
instance (with both workbooks open), enter this in sheet "Hidden" in
Workbook2:


A

1 =[Workbook1.xlsx]Sheet1!$J$1
2 =[Workbook1.xlsx]Sheet1!$J$2
....

then name THAT range on sheet "Hidden" the way you would for any other
intra-workbook dropdown.