need Excel function like INDIRECT but can't open all spreadsheets
Need to reference values in multiple spreadsheets using function like
INDIRECT, but I can not have all of the spreadsheets open a the same time. |
INDIRECT only works with open spreadsheets. You could try Harlan Grove's
Pull function, which you can get at ftp://members.aol.com/hrlngrv/pull.zip -- HTH RP (remove nothere from the email address if mailing direct) "Big Al" <Big wrote in message ... Need to reference values in multiple spreadsheets using function like INDIRECT, but I can not have all of the spreadsheets open a the same time. |
All times are GMT +1. The time now is 05:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com