Copy columns

Closed
nivi - Jun 27, 2011 at 12:58 AM
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
- Jun 27, 2011 at 02:25 AM
Hello, i need to copy column values from 1 worksheet into another if the em id is the same in the two worksheets...

that means worksheet 1 has empid and another has emp_staffid
if they are equal then i have to copy empname to worksheet 1 column F

i am new to vba and i have to write a macro..
please help

also there are emp id in either worksheet whch will not match...

1 reply

RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Jun 27, 2011 at 02:25 AM
Use Vlookup it will helps you,

if still problem is unsolved please upload a sample EXCEL file WITH sample data on some shared site like https://authentification.site
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.


Note: your data need not be to be real data but a good representative of how data looks like
0