Excel Master Worksheet

External Since: Jan 30, 2007 Posts: 1

I am trying to create a workbook that contains multiple worksheets that will
have all the same information in the first two columns. Is there a way to
create one master sheet that will update the other worksheets if I should add
or delete a row in the master?

External Since: Mar 07, 2004 Posts: 3827

In article <0291441C-ABE3-4E59-9415-6A476041BC96 RemoveThis @microsoft.com>,
jc13044 <jc13044 RemoveThis @discussions.microsoft.com> wrote:

> I am trying to create a workbook that contains multiple worksheets that will
> have all the same information in the first two columns. Is there a way to
> create one master sheet that will update the other worksheets if I should add
> or delete a row in the master?

There's no way to automatically do this using only XL functions. You can
certainly do it using macros, though depending on what changes you make,
that could be fairly complex.

You can manually do it by selecting ALL the sheets before adding or
deleting rows (select the left-most sheet, then Shift-click the
right-most worksheet tab).

Just be sure that you then unselect all sheets (ctrl-click a worksheet
tab and choose Ungroup Sheets) before making any *other* changes or
they'll be made on all sheets.