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.

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.

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.

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.