Formatting Cells between Spreadsheets

  • Thread starter Thread starter faist001
  • Start date Start date
F

faist001

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
 
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...
 
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
 
hi
you could use a formula on sheet 2.
in sheet 2 cell A1 enter......=sheet1!A1
this would return to sheet2 cell A1 whatever is in sheet1 cell A1.
since it is a formula the change on sheet 2 would be near immediate.
the formula would adjust as you copy down and accross.

regards
FSt1
 
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
 
Back
Top