Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Paul Bond
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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
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
Is it possible? DakotaNJ Excel Worksheet Functions 25 September 18th 06 09:30 PM
Again-revealing the contents of formula srinivasan Excel Worksheet Functions 0 July 5th 05 06:25 AM
Formula to return cell contents based on multiple conditions Bill Excel Worksheet Functions 3 January 19th 05 10:59 AM
How do I add a date formula to a cell but hide the contents with . Emzy Wemzy Excel Discussion (Misc queries) 2 December 12th 04 02:48 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM


All times are GMT +1. The time now is 01:52 PM.

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"