VBA Macro for Multiple Columns

johnny_raman

New Member
Joined
Mar 26, 2014
Messages
22
Hi,

I am looking to run Vlookup formual for below table from the 3 subsequent tables (Alpha, Bravo & Charlie) below for each month with each sub columns such as Alpha, Bravo and Charlie.

Request your help in creating a Macro coding to avoid manual vlookup to fetch data in the first table.

Kindly apologies as i am not able to paste the table formatted. I would require copy paste to excel.

Thanks





April May June July
Location AC Model Customer Name ALPHA BRAVO CHARLIE ALPHA BRAVO CHARLIE ALPHA BRAVO CHARLIE ALPHA BRAVO CHARLIE
Bangalore Haier Johnny
Bangalore LG Johnny
Bangalore Blue Star Harish
Mumbai Blue Star Mahesh
Mumbai LG Asha
Mumbai Voltas Vikram
Chennai Voltas Harish
Chennai Blue Star Johnny
Chennai Blue Star Vikram



ALPHA
Location AC Model Customer Name Apr May Jun Jul
Bangalore Haier Johnny
Bangalore LG Johnny
Bangalore Blue Star Harish $27,779 $27,504
Mumbai Blue Star Mahesh $18,847 $35,000
Mumbai LG Asha $37,900 $37,900
Mumbai Voltas Vikram
Chennai Voltas Harish
Chennai Blue Star Johnny $27,675 $18,450 $55,350 $18,450
Chennai Blue Star Vikram $9,550 $49,465

BRAVO
Location AC Model Customer Name Apr May Jun Jul
Bangalore Haier Johnny
Bangalore LG Johnny
Bangalore Blue Star Harish $27,779 $27,504
Mumbai Blue Star Mahesh $18,847 $35,000
Mumbai LG Asha $37,900 $37,900
Mumbai Voltas Vikram
Chennai Voltas Harish
Chennai Blue Star Johnny $27,675 $18,450 $55,350 $18,450
Chennai Blue Star Vikram $9,550 $49,465

CHARLIE
Location AC Model Customer Name Apr May Jun Jul
Bangalore Haier Johnny $152 $2,322 $56
Bangalore LG Johnny $1 $320 $5
Bangalore Blue Star Harish $321 $1 $5,551
Mumbai Blue Star Mahesh $11,212
Mumbai LG Asha $1,232
Mumbai Voltas Vikram $321 $321 $55
Chennai Voltas Harish $32
Chennai Blue Star Johnny
Chennai Blue Star Vikram
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Please see below table:


April May June July
Location AC Model Customer Name ALPHA BRAVO CHARLIE ALPHA BRAVO CHARLIE ALPHA BRAVO CHARLIE ALPHA BRAVO CHARLIE
Bangalore Haier Johnny
Bangalore LG Johnny
Bangalore Blue Star Harish
Mumbai Blue Star Mahesh
Mumbai LG Asha
Mumbai Voltas Vikram
Chennai Voltas Harish
Chennai Blue Star Johnny
Chennai Blue Star Vikram



ALPHA
Location AC Model Customer Name Apr May Jun Jul
Bangalore Haier Johnny
Bangalore LG Johnny
Bangalore Blue Star Harish $27,779 $27,504
Mumbai Blue Star Mahesh $18,847 $35,000
Mumbai LG Asha $37,900 $37,900
Mumbai Voltas Vikram
Chennai Voltas Harish
Chennai Blue Star Johnny $27,675 $18,450 $55,350 $18,450
Chennai Blue Star Vikram $9,550 $49,465

BRAVO
Location AC Model Customer Name Apr May Jun Jul
Bangalore Haier Johnny
Bangalore LG Johnny
Bangalore Blue Star Harish $27,779 $27,504
Mumbai Blue Star Mahesh $18,847 $35,000
Mumbai LG Asha $37,900 $37,900
Mumbai Voltas Vikram
Chennai Voltas Harish
Chennai Blue Star Johnny $27,675 $18,450 $55,350 $18,450
Chennai Blue Star Vikram $9,550 $49,465

CHARLIE
Location AC Model Customer Name Apr May Jun Jul
Bangalore Haier Johnny $152 $2,322 $56
Bangalore LG Johnny $1 $320 $5
Bangalore Blue Star Harish $321 $1 $5,551
Mumbai Blue Star Mahesh $11,212
Mumbai LG Asha $1,232
Mumbai Voltas Vikram $321 $321 $55
Chennai Voltas Harish $32
Chennai Blue Star Johnny
Chennai Blue Star Vikram
 
Upvote 0

Forum statistics

Threads
1,223,275
Messages
6,171,126
Members
452,381
Latest member
Nova88

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top