ExcelBanter - Find and copy??

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Find and copy?? (https://www.excelbanter.com/excel-worksheet-functions/9241-find-copy.html)

Have the below formula but need to replace the dates (January) with
corresponding date across top of work sheet., Febuary, March, etc.etc.

Is there a way to do it w/o retyping, and making mistakes?

Thanks,
L.

=IF(SUM('January 2005'!C16,'January 2005'!E16,'January
2005'!G16)=0,"",IF(SUM('January 2005'!C16,'January 2005'!E16,'January
2005'!G16)='January 2005'!$B16,"P","X"))

I know someone will know a much better way, because I am just learning this.
If you copy it to all of the sells you want the formula in, select Tools,
Options, View, Formulas, selct the first cell you want to replace the January
and then do Edit, Search, Replace, Replace All. At most, you wil just have to
do it 11 times and the default search will remain January after you do it
once.
Gary

"L/P" wrote:

Have the below formula but need to replace the dates (January) with
corresponding date across top of work sheet., Febuary, March, etc.etc.

Is there a way to do it w/o retyping, and making mistakes?

Thanks,
L.

=IF(SUM('January 2005'!C16,'January 2005'!E16,'January
2005'!G16)=0,"",IF(SUM('January 2005'!C16,'January 2005'!E16,'January
2005'!G16)='January 2005'!$B16,"P","X"))