KK1966
03-15-2009, 07:02 AM
Hi
I wanted help to Vlookup in Vba
Situation is there
Sheet1” COL, A2 to A which is a customer named COL B2 to B is the TEL and COL C is contact person.( data is too much about 6500 or above and that’s are past years ago old)
Sheet2” Col A is the current own customers, how do I made VBA to Vlookup base the customer to match (since might typing mode are diffidence) then sheet2 COL B” = Tel, COL C” = the contact persons ?
I want to use Vlookup in a vba module, but i can't figure it out how to do this...
Please help :help
I wanted help to Vlookup in Vba
Situation is there
Sheet1” COL, A2 to A which is a customer named COL B2 to B is the TEL and COL C is contact person.( data is too much about 6500 or above and that’s are past years ago old)
Sheet2” Col A is the current own customers, how do I made VBA to Vlookup base the customer to match (since might typing mode are diffidence) then sheet2 COL B” = Tel, COL C” = the contact persons ?
I want to use Vlookup in a vba module, but i can't figure it out how to do this...
Please help :help