hey, im having trouble with one of these functions that im trying to
use....

im making a spreadsheet that needs two pages linked together and those
functions need to be linked to another cell in one of them.

heres how the function looks so far

='[EXCEL TRIAL.xls]TOOLS'!$A$9016

but instead of the 9016 i need to to be more like another function

='[EXCEL TRIAL.xls]TOOLS'!$A$(=b1) or something around those lines so
when i put a number in B1 on one sheet, it will change the cells being
used in the opposite one.

if anyone can help me, you can send an email to


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