#1   Report Post  
kellerfro
 
Posts: n/a
Default 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

  #2   Report Post  
MrShorty
 
Posts: n/a
Default


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

  #3   Report Post  
kellerfro
 
Posts: n/a
Default


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

  #4   Report Post  
MrShorty
 
Posts: n/a
Default


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

  #5   Report Post  
kellerfro
 
Posts: n/a
Default


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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel option to store trendline's coefficients in cells for use Miguel Saldana Charts and Charting in Excel 9 June 20th 05 08:45 PM
i want to use the =if function to apply a colour to other cells pookie1970 Excel Worksheet Functions 1 June 20th 05 05:53 PM
What function can make cells shift up when they are blank? Julie Excel Worksheet Functions 0 March 26th 05 08:31 PM
how do i seprate multi data cell into 2 or more cells vinlouis New Users to Excel 2 February 22nd 05 06:26 PM
Function to return the latest non-zero value in a range of cells . hungryman Excel Worksheet Functions 2 January 24th 05 03:54 PM


All times are GMT +1. The time now is 09:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"