I currently have the following formula:
=INDIRECT($A$1&".xls!A1").
I need to drag and increment the formula but it won't work.
Desired results:
INDIRECT($A$1&".xls!A2")
INDIRECT($A$1&".xls!A3")
etc.
Thanks in advance for your help.
I currently have the following formula:
=INDIRECT($A$1&".xls!A1").
I need to drag and increment the formula but it won't work.
Desired results:
INDIRECT($A$1&".xls!A2")
INDIRECT($A$1&".xls!A3")
etc.
Thanks in advance for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks