Hi,
I need to populate almost 10 columns with information from another excel sheet. We usually do it using vlookup.
Can we use a macro and automate it. SO that I just click once and all the columns gets populates.
Table A where the information needs to be populated
<tbody>
</tbody>
Table B which contains information which is required in table A
<tbody>
</tbody>
Regards,
Keshav
I need to populate almost 10 columns with information from another excel sheet. We usually do it using vlookup.
Can we use a macro and automate it. SO that I just click once and all the columns gets populates.
Table A where the information needs to be populated
IP | Location | Metal category | Teams | Application Hosted | Owner | ||||
1.1.1.1 | |||||||||
1.1.1.2 | |||||||||
1.1.1.3 | |||||||||
1.1.1.2 |
<tbody>
</tbody>
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 | 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 |
<tbody>
</tbody>
Regards,
Keshav