Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
SMullins
 
Posts: n/a
Default Sheet name in formula

This is a formula I us daily

(example)
='V:\Production Reporting Summaries\Tammy\April 05\[Production
Summary.xls]4_04'!$B$4

each day I have to make a copy the previous days worksheet and then go into
multiply cells and change 4_04 to the next day, which would be 4_05.

I want to be able to enter 4_05 into one cell and have it update 4_04
automatically so I am not manually changing the formula daily.

  #2   Report Post  
Ron Coderre
 
Posts: n/a
Default

Is there a reason you can't use Excel's Search/Replace?

EditReplace
Find what: 4_04
Replace with: 4_05

That should replace every instance of 4_04 in your worksheet with 4_05.

Does that help?

Regards,
Ron
  #3   Report Post  
SMullins
 
Posts: n/a
Default

This would change soom parts of a formula in the sheet that I do not want
changed.

"Ron Coderre" wrote:

Is there a reason you can't use Excel's Search/Replace?

EditReplace
Find what: 4_04
Replace with: 4_05

That should replace every instance of 4_04 in your worksheet with 4_05.

Does that help?

Regards,
Ron

  #4   Report Post  
LanceB
 
Posts: n/a
Default

Look at indirect
example

in a1 the text
'Sheet2!
=INDIRECT(A1&"c2")
will refererence c2 on sheet 2
=INDIRECT(A1&"d9")
will refererence d9 on sheet 2

Then all that has to change is the one reference in a1




"SMullins" wrote:

This is a formula I us daily

(example)
='V:\Production Reporting Summaries\Tammy\April 05\[Production
Summary.xls]4_04'!$B$4

each day I have to make a copy the previous days worksheet and then go into
multiply cells and change 4_04 to the next day, which would be 4_05.

I want to be able to enter 4_05 into one cell and have it update 4_04
automatically so I am not manually changing the formula daily.

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
Sheet name in formula SMullins Excel Worksheet Functions 8 April 8th 05 04:54 PM
Match / Vlookup within an Array formula Hari Prasadh Excel Discussion (Misc queries) 3 February 3rd 05 05:37 PM
How do I set up a formula on a time sheet to calculate time in 1/. gschmid Excel Discussion (Misc queries) 2 January 18th 05 02:48 PM
Need formula for sheet & cell reference MPH Excel Worksheet Functions 0 January 16th 05 04:39 PM
Help with macro formula and variable Huge project Excel Worksheet Functions 0 December 28th 04 02:27 AM


All times are GMT +1. The time now is 11:15 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"