| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
changing a formula in multiple cells
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
changing a formula in multiple cells
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. casdaq wrote: 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! -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
changing a formula in multiple cells
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. -- Gary''s Student - gsnu200718 "casdaq" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy formula into multiple cells without changing range | Excel Worksheet Functions | |||
| help me is it possible to add to multiple cells without changing t | Excel Worksheet Functions | |||
| Pasting a formula in multiple cells without changing the range | Excel Discussion (Misc queries) | |||
| changing cells in multiple worksheets | Excel Worksheet Functions | |||
| changing multiple cells from relative to absolute reference | Excel Discussion (Misc queries) | |||
Hybrid Mode
