Assume source is Sheet1 cols A to C
In Sheet2,
In A1: =IF(Sheet1!A1="","",Sheet1!A1)
Copy across to C1, fill down to cover the max expected extent of source data
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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