Thread: Find and copy??
View Single Post
  #1   Report Post  
L/P
 
Posts: n/a
Default Find and copy??


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"))