Update forumla in same cell on each sheet
 

Is it possible to update the formula for the same cell on each worksheet of a
workbook without having to individually change each one?

Hi
Yes it is possible.
Add the sheets in your selection using the Ctrl Key and clicking the
relevant worksheets tabs
Place your formula, validate and ungroup the sheets.

HTH
Cordially
Pascal

"Ellen" a écrit dans le message de news:
...
Is it possible to update the formula for the same cell on each worksheet
of a
workbook without having to individually change each one?

Thank you. This did what we were looking for.

"papou" wrote:

Hi
Yes it is possible.
Add the sheets in your selection using the Ctrl Key and clicking the
relevant worksheets tabs
Place your formula, validate and ungroup the sheets.

HTH
Cordially
Pascal

"Ellen" a écrit dans le message de news:
...
Is it possible to update the formula for the same cell on each worksheet
of a
workbook without having to individually change each one?