Here is 1 option. However, you would only be able to change it in one sheet,
so if you have SHEET1 & SHEET2. only SHEET2 would be modifiable.

Place this Formula in Sheet1, cell A1 to have it be identical to whatever is
in Sheet2, cell A1
"=Sheet2!A1"

ron

"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