[INDIRECT] Syntax Help
OK MAX,
Hope this reply is correct enough.
And if you would have read what I stated carefully, It didn't seem to work.
I did use your suggestion of doing the calcs on the host Worksheet, but I'm
still not getting the results I need.
I Understand the phrase that you gave before, but I'm not seeing the
&rows($1:1)+1) portion....can you explain it?
"Max" wrote:
I will need to copy that code from row to row....
linking each row as i go down the list.
.. What would the Syntax need to be to autocopy down a column?
Hey..if you had read carefully, I covered the above point in this part of my
response:
And if you need it to increment copying down,
use something like this: INDIRECT("'"&J2&"'!HZ"&rows($1:1)+1)
p/s: Btw, learn how to reply properly in the newsgroup. Don't reply to your
own post, reply to the responder
--
Max
Singapore
---
"ThunderBlade" wrote:
That didn't seem to work. It worked as long as the rows didn't have to move.
Once I have the code line in the "PeriodHours" Worksheet I will need to copy
that codce from row to row....linking each row as i go down the list.
Basically, the code would need to do this as I go down the rows:
=IF(B5="Salary",96,INDIRECT((J2)&"!HZ2"-INDIRECT((J2)&"!IB2"-INDIRECT((J2)&"!ID2"))))
=IF(B5="Salary",96,INDIRECT((J2)&"!HZ3"-INDIRECT((J2)&"!IB2"-INDIRECT((J2)&"!ID3"))))
=IF(B5="Salary",96,INDIRECT((J2)&"!HZ4"-INDIRECT((J2)&"!IB2"-INDIRECT((J2)&"!ID4"))))
This would populate the data onto the "PeriodHours" Worksheet from the
subsequent worksheets. What would the Syntax need to be to autocopy down a
column?
|