Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding the contents of a cell to a formula
I have information held in a separate worksheet and the name of the worksheet
is changing constantly. Within a cell on my current worksheet I have the file details of where the information I require is to be obtained. I want to create a formula that takes the file details from the cell above and adds it to the formula so it knows where to find the information i require The contents of a cell in my spreadsheet contains a file and worksheet reference eg [china garden week 74.xls]Sheet1!$D$15 The contents of this cell is updated by a formula each time the week number changes. Therefore the number "74" is always changing I want to enter a formula to return the value in the worksheet cell stated above without having to amend the formula each time the filename changes. I cannot use the indirect function as the spreadsheets I wish to link to will not always be open. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding the contents of a cell to a formula
Take a look at Harlan Grove's PULL function that does do that
ftp://members.aol.com/hrlngrv/ Look for pull.zip -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Paul Bond" wrote in message ... I have information held in a separate worksheet and the name of the worksheet is changing constantly. Within a cell on my current worksheet I have the file details of where the information I require is to be obtained. I want to create a formula that takes the file details from the cell above and adds it to the formula so it knows where to find the information i require The contents of a cell in my spreadsheet contains a file and worksheet reference eg [china garden week 74.xls]Sheet1!$D$15 The contents of this cell is updated by a formula each time the week number changes. Therefore the number "74" is always changing I want to enter a formula to return the value in the worksheet cell stated above without having to amend the formula each time the filename changes. I cannot use the indirect function as the spreadsheets I wish to link to will not always be open. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
Again-revealing the contents of formula | Excel Worksheet Functions | |||
Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
How do I add a date formula to a cell but hide the contents with . | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |