• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 239
  • Last Modified:

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
0
starport
Asked:
starport
1 Solution
 
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
 
Saqib Husain, SyedEngineerCommented:
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
 
Eric ZwiekhorstCommented:
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now