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
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]IP[/TD]
[TD]Location[/TD]
[TD]Metal category[/TD]
[TD]Teams[/TD]
[TD]Application Hosted[/TD]
[TD]Owner[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1.1.1.1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1.1.1.2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1.1.1.3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1.1.1.2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Table B which contains information which is required in table A
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]IP[/TD]
[TD]Location[/TD]
[TD]Metal Category[/TD]
[TD]Teams[/TD]
[TD]Application Hosted[/TD]
[TD]Owner[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1.1.1.1[/TD]
[TD]UK[/TD]
[TD]Iron[/TD]
[TD]Windows[/TD]
[TD]MS Outlook[/TD]
[TD]A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1.1.1.2[/TD]
[TD]USA[/TD]
[TD]Iron[/TD]
[TD]Unix[/TD]
[TD]Email[/TD]
[TD]B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1.1.1.3[/TD]
[TD]Australia[/TD]
[TD]Gold[/TD]
[TD]Unix[/TD]
[TD]Sharepoint[/TD]
[TD]A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1.1.1.4[/TD]
[TD]UK[/TD]
[TD]Silver[/TD]
[TD]Unix[/TD]
[TD]Sharepoint[/TD]
[TD]A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1.1.1.5[/TD]
[TD]India[/TD]
[TD]Bronze[/TD]
[TD]Windows[/TD]
[TD]Vmware[/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]IP[/TD]
[TD]Location[/TD]
[TD]Metal category[/TD]
[TD]Teams[/TD]
[TD]Application Hosted[/TD]
[TD]Owner[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1.1.1.1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1.1.1.2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1.1.1.3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1.1.1.2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Table B which contains information which is required in table A
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]IP[/TD]
[TD]Location[/TD]
[TD]Metal Category[/TD]
[TD]Teams[/TD]
[TD]Application Hosted[/TD]
[TD]Owner[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1.1.1.1[/TD]
[TD]UK[/TD]
[TD]Iron[/TD]
[TD]Windows[/TD]
[TD]MS Outlook[/TD]
[TD]A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1.1.1.2[/TD]
[TD]USA[/TD]
[TD]Iron[/TD]
[TD]Unix[/TD]
[TD]Email[/TD]
[TD]B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1.1.1.3[/TD]
[TD]Australia[/TD]
[TD]Gold[/TD]
[TD]Unix[/TD]
[TD]Sharepoint[/TD]
[TD]A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1.1.1.4[/TD]
[TD]UK[/TD]
[TD]Silver[/TD]
[TD]Unix[/TD]
[TD]Sharepoint[/TD]
[TD]A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1.1.1.5[/TD]
[TD]India[/TD]
[TD]Bronze[/TD]
[TD]Windows[/TD]
[TD]Vmware[/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Regards,
Keshav