Hello, I'm trying to create a summary sheet. I have template documents that are identical accept for the values. I want to be able to create a formula that I can drag down a column that will adjust the file it is linked to by 1. ie in cell A1 links to 'File1!A1', B1 links to 'File2!A1', and so on I have played around but really cant figure it out??
Thank you in advance
You need something like
=INDIRECT("File"&ROW()&"!A1")
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
I am aware of the indirect function but how would I do it if the files are closed? would I need to use a macro to open the files extract the data and close the files?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks