Hi,
I need to populate almost 10 columns with information from another excel sheet. We usually do it using vlookup.
I want to use a macro and automate it. SO that in just one click all the fields gets populated and saved.
Table A where the information needs to be populated
IP Location Metalcategory Teams Application Hosted Owner
1.1.1.1
1.1.1.2
1.1.1.3
1.1.1.2
Table B which contains information which is required in table A
IP Location Metal Category Teams Application Hosted Owner
1.1.1.1 UK Iron Windows MS Outlook A
1.1.1.2 USA Iron Unix Email B
1.1.1.3 Australia Gold Unix Sharepoint A
1.1.1.4 UK Silver Unix Sharepoint A
1.1.1.5 India Bronze Windows Vmware C
Regards,
Keshav
Bookmarks