changing a formula in multiple cells

C

casdaq

I'm not sure if this is possible but is there a way to change just one
portion of a fomula in mulitiple cells? I have a report that has monthly
results listed on one tab abd this reprot pulls the data from another
worksheet, where the data is on different tabs for each month. The cells stay
the same for each tab but I need to change the formula on my report to
reflect the new month. I was hoping there is any easier solution then
manually typing the new month in each cell. There are quite a few cells...

Here is the formula...

='[data sheet.xls]Mar'!$C24

I need to change it to reflect April, May and so on without having to
manually changing it.

Let me know if this doesn't make sense. :0) Thanks in advance!
 
D

Dave Peterson

How about selecting that range to fix and then
edit|replace
what: Mar
with: April
replace all

Be careful with your typing. It'll be a pain if you make a typo.
I'm not sure if this is possible but is there a way to change just one
portion of a fomula in mulitiple cells? I have a report that has monthly
results listed on one tab abd this reprot pulls the data from another
worksheet, where the data is on different tabs for each month. The cells stay
the same for each tab but I need to change the formula on my report to
reflect the new month. I was hoping there is any easier solution then
manually typing the new month in each cell. There are quite a few cells...

Here is the formula...

='[data sheet.xls]Mar'!$C24

I need to change it to reflect April, May and so on without having to
manually changing it.

Let me know if this doesn't make sense. :0) Thanks in advance!
Click to expand...
 
G

Gary''s Student

Instead of:

='[data sheet.xls]Mar'!$C24

use something like:

=INDIRECT("'[data sheet.xls]" & A1 & "!$C2")

where A1 can contain Mar or Apr...You can then change all the sheet
references by changing just one cell.
 
Top