If your worksheets all have the same structure (i.e the data is in the same
place and the formulas are to go in the same cells, then you can group the
worksheets and type the formula once.

Click the tab for the first worksheet; hold SHIFT and click the tab of the
last one (note how all the tabs between first and last now have the same
appearance); type formula in the cell and commit it (press ENTER, or use
green check mark in formula bar, etc); click a single worksheet tab to
ungroup.
Now all sheets have same formula.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Karen" wrote in message
...
I have to calculate the minimum and the maximum on the same range of cells
across multiple worksheets. I thought that I would just set up the cell to
calculate the minimum and then just copy and paste the formula in the cell
for the max. and then just change the =MIN to =MAX. When I do this, the
column references change. I'm guessing that the cell references have to be
absolute. Since I have all the minimums calculated, what is an easy way to
calculate the maximum so I don't have to choose each cell across the
worksheets again or change the column references?
Thanks, Karen