Link to home
Start Free TrialLog in
Avatar of starport
starportFlag for Canada

asked on

Indirect function

earlier in this thread, you proviided an example that allowed me to use the indirect funtion to draw data into a master spreadsheet; this worked well.  Now I have run into a situation, where I'd like to draw and sum numerical data from my referenced worksheets, but i'm finding that the references remain absolute in the master; i

Speciifically,  when, on one of the referenced sheets, I insert a line (to add new numerical data), the new celll (now one line lower) is not referenced anymore from the master; it has remained the same and has not adjusted.  This is a hard question to word.  Hopefully makes some sense.  Thanks in advance

David
Avatar of nutsch
nutsch
Flag of United States of America image

As stated in the previous question

=indirect(A1&"!a1")
will give the value in A1 of the sheet whose name is in A1 of the current sheet.

If you want the row to follow when you copy down, you can use something like
=indirect($A$1&"!a" & row())

Thomas
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Dear starport,

The reason why indirect exists is the static behaviour.
If you dant you cells to follow insertin an deleting cells please use you formula without the indirect and it will do jst that..


Kind regards

Eric