Excel Master Worksheet

[jc13044]

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?

 

[JE McGimpsey]

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.