Replace Columns

[AmyB]

Hi,

I need some help. I need to replace an unsorted, unfiltered column
from one worksheet with a column from a second worksheet. My problem
is that I need to keep the rest of the columns in the worksheet
exactly the same. Is there a way I can link, group, or associate (not
sure of the precise word) two or more columns? In order to understand
the spreadsheet, the order must not change yet I have to replace the
contents with unfiltered content. Is there an easy way to do this?

For example, I always want A1 to be associated with C1, D1, E1, F1,
G1.

Thanks in advance!

 

[ozgrid.com]

In the cells you want associated with A1, Enter =A1

 

[AmyB]

In the cells you want associated with A1, Enter =A1

Thanks, Dave! This is a cool tip, but it doesn't solve my problem. I
don't want two columns to have the same information. Instead, if I
import new data from a separate worksheet I want there to be a way for
the new data to always seek out and line up with the old.

For example, if I have a person's last name in column A. First name in
column B. Address in column C. I receive a separate spreadsheet from a
co-worker who has similar information only more. With thousands of
rows of information, I can't tell why or where the differences occur.
Instead, I want to take his column C and import to my worksheet but I
want to keep the data in columns A and B in the same order. "Brown" in
column A should always line up with "Amy" in column B and "123 Pinola
Road" in column C. Is there an easy way to do this? A macro?