Paulfakins
New Member
- Joined
- Oct 9, 2003
- Messages
- 29
I have the following as the source for a data validation list:
=INDIRECT(CONCATENATE("[Workbook1.xls]Sheet1!",A1))
where A1 will contain the name of the range I want to use as the list. This works fine as long as Workbook1 is open.
Is there a way to do this if Workbook1 is closed? I can't seem to get it to work even if I use the full path for the workbook.
e.g. =INDIRECT(CONCATENATE("c:Documents\data\[PipePrice.xls]Pipe!",C12))
Any advice would be appreciated
Paul
=INDIRECT(CONCATENATE("[Workbook1.xls]Sheet1!",A1))
where A1 will contain the name of the range I want to use as the list. This works fine as long as Workbook1 is open.
Is there a way to do this if Workbook1 is closed? I can't seem to get it to work even if I use the full path for the workbook.
e.g. =INDIRECT(CONCATENATE("c:Documents\data\[PipePrice.xls]Pipe!",C12))
Any advice would be appreciated
Paul