Formula Help??

[Guest]

I'm creating a huge spreadsheet. This is an example of one of the formulas
that I'm using
(=SUMPRODUCT(--(March!$C$3:$C$18="2E"),--(March!$F$3:$F$18="head")). Now
since I have a spreadsheet created for each month it is very time consuming
to go in and change 30+ formulas so that it is calculating for April, then
May, June. Is there a function that I can type in so that the formula will
automatically pick up the name of the spreadsheet???

Thank you for you help.

 

[Vasant Nanavati]

Just do a Search and Replace.

 

[Guest]

What exactly is a search and replace?

Just do a Search and Replace.

 

[Guest]

Thank You!!!!

I thought it would have been alot harder!!!