Group the worksheets by click the tab for the first sheet; hold SHIFT and
click the tab for the last one (if non-contiguous, use CTRL)
Type the formula
Ungroup by clicking any one of the worksheet tabs
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"Meenie" wrote in message
...
I want to enter info in cell L25 on one worksheet and have it show up in
cell
L25 or several other worksheets without having to go to each worksheet and
in
that cell hitting =, then clicking on the original cell over and over, is
this possible?
Thanks