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
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.
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.
What should I do? THANK YOU!