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.
|