Excel Master Worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jc13044 - 30 Jan 2007 15:55 GMT

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?

Reply to this Message

JE McGimpsey - 30 Jan 2007 18:07 GMT

> 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.

Reply to this Message

Mac Forum / Applications / Excel / January 2007

Excel Master Worksheet