thanks for the help mr shorty, im going to try that out right now, and
ill repost if i have any other problems


ok, on this i dont know if its doing what i needed, so im goin to try
to explain this better than the first time...

='[EXCEL TRIAL.xls]TOOLS'!$B$*9016* i need a way to change that row
position from another cell, the whole indirect stuff just was giving
me one number or #ref errors.

i dont even know if its possible for there to be another simultaneous
functions happening in that cell

='[EXCEL TRIAL.xls]TOOLS'!$B$*a cell on sheet1*

i tried the INDIRECT function with both sheets and i couldnt get it to
work, but ill keep trying and if i figure it out ill post again....
wish me luck


--
kellerfro
------------------------------------------------------------------------
kellerfro's Profile: http://www.excelforum.com/member.php...o&userid=24675
View this thread: http://www.excelforum.com/showthread...hreadid=382483