Replacing part of a formula

  • Thread starter Thread starter PNCC
  • Start date Start date
P

PNCC

Currently I am working on a project that uses formulas to referenc
another sheet in the workbook. I plan to use the newly created shee
monthly. However I am in need of changing part of the cell formula.
Example one cell says =Nov!D12 and I am needing to change it to rea
=Dec!D12 or =Jan!D12 etc....

Any help
 
One way is to use the INDIRECT function when creating your formulas, eg:-

Assuming your month was in say A3 then =INDIRECT(A3&"!A1") will give you the
data from cell A1 on whatever sheet is listed in A3.

Another option is to just use Edit / Replace, replacing Jan! with Feb! etc.
Make sure in the Edit / Replace options you do nor have it set to Match Entire
cell contents. If you select only a single cell it will apply it to the whole
sheet, or if you select a range it will apply it to that.
 
Back
Top