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
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