Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
i want to use the =if function to apply a colour to other cells | Excel Worksheet Functions | |||
What function can make cells shift up when they are blank? | Excel Worksheet Functions | |||
how do i seprate multi data cell into 2 or more cells | New Users to Excel | |||
Function to return the latest non-zero value in a range of cells . | Excel Worksheet Functions |