Duplicate Columns on Different Sheets

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

Assuming I have a column on Sheet1 named "Customers1" and another colum
named "Customers2" on Sheet2, is there a way that I can automaticall
copy any data inputed from Customers1 to Customers2?

I currently use =IF(ISBLANK(Sheet1!A1),"",Sheet1!A1) and drag a
necessary. This works well but if I insert rows into Sheet1, then
must remember to insert the same row into Sheet2.

I was thinking if I could automtically copy an entire column, thi
would a) make things easy and b) decrease the possibility of error
 
Andrew,

Name the entire column on sheet 1. Say the name is MyData.
In sheet 2 select the entire column and insert this
formula "=Mydata".

This will eliminate the need to insert same rows in sheet1.
 
Thanks.

I've tried something like this before, but it only seems to work fo
the very top row.

Maybe I'm doing something wrong....it's driving me crazy!!! :
 
Andrew,

Try the following:
Say your data is in Column A of sheet 1.

Select entire column A in sheet 1. Then do
Insert>>Name>>Define. In the dialogue box type MyData.
Notice that at the bottom of the dialogue box Sheet1!$A:$A
should appear.

Select entire Column A in Sheet 2. Type the formula
=MyData. Do not get it by pointing. Now press Ctl+Enter.

This shoud work. I assume you want identical information
in both column rows.

Thanks

Jamal

Trytyping the formula =MyData and then Ctl+Enter for the
entire column in sheet 2. Do not get the Name by pointing.
 
Back
Top