Duplicate Columns on Different Sheets

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
 
G

Guest

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.
 
A

Andrew

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!!! :
 
J

Jamal

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.
 
Top