Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto update of cell information | Excel Discussion (Misc queries) | |||
up to 7 functions? | Excel Worksheet Functions | |||
IF command in Excel | Excel Discussion (Misc queries) | |||
if a cell contains certain text, cut and paste to another sheet | Excel Worksheet Functions | |||
Need formula for sheet & cell reference | Excel Worksheet Functions |