Formulas
 

I have a workbook with a variety on of worksheets. I've created a worksheet
that gets information from each of the worksheets and displays it on the same
worksheet. I use the following formula in one of my cells:

='June 3'!$B$4

I can get the information that I need. Now, that I have this worksheet set
up, I would like to use it in other workbooks, but they have different names
on each of their worksheets. Is there a way to write the formula so it knows
to take the information from the current worksheets in the workbook in which
the formula page has been pasted??? Right now, I've been re-typing the
formula page in each workbook and it is very laborious....The cell reference
will always be the same. It is only the name of the worksheets that change
in the different workbooks....

Thanks for any help that can be provided!!

If you don't have too many sheets
hylight your formula sheet and use find replace to change the sheet names
for example if you have 'Jun 3' in the old book and your new book has 'Jul 7'
use Find 'Jun 3' replace with 'Jul 7'

use caustion whenever you use the global replace, diferent versions of
Excel do slightly different things . Try it on a copy before you do it on
your master document.

"Tia" wrote:

I have a workbook with a variety on of worksheets. I've created a worksheet
that gets information from each of the worksheets and displays it on the same
worksheet. I use the following formula in one of my cells:

='June 3'!$B$4

I can get the information that I need. Now, that I have this worksheet set
up, I would like to use it in other workbooks, but they have different names
on each of their worksheets. Is there a way to write the formula so it knows
to take the information from the current worksheets in the workbook in which
the formula page has been pasted??? Right now, I've been re-typing the
formula page in each workbook and it is very laborious....The cell reference
will always be the same. It is only the name of the worksheets that change
in the different workbooks....

Thanks for any help that can be provided!!