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
starportAsked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
you can try something like

=indirect(address(rownumber,columnnumber,,,sheetname))

where the bold text should be replaced with values or cell addresses which contain values.

0
 
nutschCommented:
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
0
 
Eric ZwiekhorstSAP Business ConsultantCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.