You can do that by clicking the first sheet tab and Ctrl + Click on the
second sheet tab. Your formattingn in either for the selected worksheets
updates both. This includes entering data, formulas, copying, deleting and
moving.

So that you don't court a disaster, ungroup the worksheets when your
finished. Right click on either of the selected sheets and select UNGROUP.

Hope this helps...
--
Kevin Backmann


"faist001" wrote:

I have two spreadsheets within one Excel File. The first 3 columns of each
spreadsheet are identical, however the following 30 columns are different.

My goal would be to keep the 3 columns between the spreadsheets identical by
doing the following:

If I change something in the first spread sheet it AUTOMATICALLY adds that
new change to the second spreadsheet.

Is this possible? any help would be great