PDA

View Full Version : VBA Code for VLOOKUP



ARUNRANA2004
06-17-2014, 11:38 AM
Hi, I'm Beginner of VBA, pls help me create the VBA for VLOOKUP for following data.
I've Book1 having 2 sheets. Sheet1 having the raw data, I want to create VLOOKUP in sheet2 to culled out the data from sheet1.

Sheet1
A B C D E F
Emp no. Emp Name Designation Date of Joining Department City
122233 abc Manager 13-06-14 Production Delhi
122234 def Executive 12-01-13 Sales Mumbai
122235 ghi President 13-01-13 Marketing Kolkata
122236 jkl officer 14-01-13 Operation Chennai
122237 mno Manager 15-01-13 Research New Delhi
122238 pqr senior Manager 16-01-13 Legal Mumbai
122239 stu senior officer 17-01-13 Development Kolkata
122240 vwx officer 18-01-13 Sales Delhi

My requirement are here-under-
When I type employee no. in any cell of column A in sheet2, Emp. name, designation, date of Joining, Department and city should be populated in corresponding cell of column B, C, D, E and F respectively.

Pls also see that vlookup formula should be hidden. also note that data in sheet1 can be go upto 5000 rows.

Pls help me.....

Aussiebear
06-17-2014, 11:01 PM
Why do you think you need vba to do something which is already a strong feature within Excel?

ARUNRANA2004
06-18-2014, 11:02 AM
Why do you think you need vba to do something which is already a strong feature within Excel?
Thanks for advise. However, when I use vlookup formula in sheet (sheet contain > 50,000 rows and 300 column) file become so heavy, that's why I want VBA.