changing a formula in multiple cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

casdaq - 30 Apr 2007 23:40 GMT

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!

Reply to this Message

Dave Peterson - 30 Apr 2007 23:47 GMT

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
[quoted text clipped - 12 lines]
>
> Let me know if this doesn't make sense. :0) Thanks in advance!

Signature

Dave Peterson

Reply to this Message

Gary''s Student - 30 Apr 2007 23:54 GMT

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.

Signature

Gary''s Student - gsnu200718

Reply to this Message