software

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
HISquot;AJ_Knightquot; gt; wrote in message
...
gt;I make constent changes in a work book that i have set up in excel. The
gt; problem is when i make a change on one page i have to make the same
gt; changes
gt; in all the pages i have. (9) Is there anyway to make a change in one page
gt; (adding / deleting rows, cells, ect..) and have that change carried over
gt; to
gt; all the other pages automaticaly?
Thanks Nick it worked
{:^)

quot;Nick Hodgequot; wrote:

gt; Be very careful this is what you want, but grouping sheets will do that. I
gt; say be careful, it is just so easy to forget they're grouped
gt;
gt; To group sheets which are contiguous, click on the first, hold the shift key
gt; and click on the last, all will be selected and [Group] will be in the
gt; workbook title bar. To select non-contiguous sheets hold down the ctrl key
gt; and click on any sheet tabs you want in the group. To de-select, click on a
gt; non-selected tab or right-click on a selected tab and select un-group
gt;
gt; --
gt; HTH
gt; Nick Hodge
gt; Microsoft MVP - Excel
gt; Southampton, England
gt; www.nickhodge.co.uk
gt; HIS
gt;
gt;
gt; quot;AJ_Knightquot; gt; wrote in message
gt; ...
gt; gt;I make constent changes in a work book that i have set up in excel. The
gt; gt; problem is when i make a change on one page i have to make the same
gt; gt; changes
gt; gt; in all the pages i have. (9) Is there anyway to make a change in one page
gt; gt; (adding / deleting rows, cells, ect..) and have that change carried over
gt; gt; to
gt; gt; all the other pages automaticaly?
gt;
gt;
gt;