I make constent changes in a work book that i have set up in excel. The
problem is when i make a change on one page i have to make the same changes
in all the pages i have. (9) Is there anyway to make a change in one page
(adding / deleting rows, cells, ect..) and have that change carried over to
all the other pages automaticaly?

Be very careful this is what you want, but grouping sheets will do that. I
say be careful, it is just so easy to forget they're grouped

To group sheets which are contiguous, click on the first, hold the shift key
and click on the last, all will be selected and [Group] will be in the
workbook title bar. To select non-contiguous sheets hold down the ctrl key
and click on any sheet tabs you want in the group. To de-select, click on a
non-selected tab or right-click on a selected tab and select un-group

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"AJ_Knight" wrote in message
...
I make constent changes in a work book that i have set up in excel. The
problem is when i make a change on one page i have to make the same
changes
in all the pages i have. (9) Is there anyway to make a change in one page
(adding / deleting rows, cells, ect..) and have that change carried over
to
all the other pages automaticaly?

Thanks Nick it worked
{:^)

"Nick Hodge" wrote:

Be very careful this is what you want, but grouping sheets will do that. I
say be careful, it is just so easy to forget they're grouped

To group sheets which are contiguous, click on the first, hold the shift key
and click on the last, all will be selected and [Group] will be in the
workbook title bar. To select non-contiguous sheets hold down the ctrl key
and click on any sheet tabs you want in the group. To de-select, click on a
non-selected tab or right-click on a selected tab and select un-group

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"AJ_Knight" wrote in message
...
I make constent changes in a work book that i have set up in excel. The
problem is when i make a change on one page i have to make the same
changes
in all the pages i have. (9) Is there anyway to make a change in one page
(adding / deleting rows, cells, ect..) and have that change carried over
to
all the other pages automaticaly?