Thread: Formula Help??
View Single Post
  #4   Report Post  
Urgent
 
Posts: n/a
Default

Thank You!!!!

I thought it would have been alot harder!!!

"Urgent" wrote:

What exactly is a search and replace?

"Vasant Nanavati" wrote:

Just do a Search and Replace.

--

Vasant

"Urgent" wrote in message
...
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.