Transferring exact values from a worksheet to another
Posted by Mark on June 06, 2001 4:52 PM
Hi, Im an Excel beginner so I guess this is pretty straight forward but I cannot find any reference.
I have two different worksheets A and B.
In Worksheet A I have a list of names in column A and a list of Yes in column B. Note that some of the cells in column B are blank. E.g.
Column A Column B
Thomas Yes
Mark Yes
John Yes
Henry
Tom Yes
Foster
Alan Yes
Anna Yes
In Worksheet B I have a list of names in column C. Some are the same as the ones in worksheet A, but they are in different order and mixed with other names. E.g.
Alan
Fred
Tom
Mick
Mark
Anna
Terry
Thomas
John
Foster
I would like to automatically import Column B from worksheet A into Worksheet B in a way that Yes appear automatically with the correspondent name. E.g.
Alan Yes
Fred
Tom Yes
Mick
Mark Yes
Anna Yes
Terry
Thomas Yes
John Yes
Foster
What should I do? THANK YOU!