Excell

  • Thread starter Thread starter deb
  • Start date Start date
D

deb

I have two columns of data that should be identical. I want the second colun
of data to change when I change the first colun so they both have the same
numbers. Is this possible.
 
hi
you could use a fomula in second column. (where are the columns?)
if sheet1 column A and B, then in column B put....
=A1
as A1 changes so does B1.
if on a different sheet, both column A then in column A sheet 2 put....
=Sheet1!A1
as sheet1 A1 changes so does sheet2 A1

draw back. it does work both ways. only changes in sheet1 A1.

Regards
FSt1
 
Back
Top