multi function cells
 

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

If Excel trial.xls will be open when the calling worksheet is open, you
can use the INDIRECT function.


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

im not too sure on how to use this INDIRECT command, if you could insert
that into an example that would be great


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

INDIRECT function is pretty well documented in Excel help. Basically
=INDIRECT('text') where text is the reference you want to pull up.
'text' can be a text literal, a reference to a cell containing text, or
a combination. For example: =INDIRECT("'[book1.xls]sheet1'!" & a1)
where A1 contaiins the text "$A$1".


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

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