rehana402003
New Member
- Joined
- Jun 9, 2016
- Messages
- 10
Hello All
I am using excel 2010 and have the problem of Consolidating my Data from 3 Sheets (image attached)
SheetV has got Data (Name1, Name2 etc) from E3 onwards (I have colored it red for sake of explanation)
SheetQ has got same Data (Name1, Name2 etc) from E3 onwards (I have colored it red).
SheetD has the names of the Dept (currently 30+)
I want a macro which should do the following consolidation for me. The macro should create the data as shown in the Result Sheet
Col A1 – Head1 which should copy the current year and month in the format yyyymm
Col B1 – Head2 which should copy the Data in Col B4 till last row from SheetV
Col C1 – Head3 which should map the Dept names from SheetD (eg. Name1 should be replaced with Dept1, Name2 with Dept2 and so on)
Col D1 – Head4 which should put the word CUR till down
Col E1 – Head5 this value will come from SheetQ (colored green for explanation)
Col F1 – Head6 this value will come from SheetV (colored blue for explanation)
The ID Column may also not have the ID numbers in same order (Please see SheetQ and SheetV)
The macro should allow to select the Range E3 onwards viz in the sample provided E3 to G13.
As the sample I have shown is for few rows and in reality it is 2000+ rows of data and 30+ names
Hope to get some help
Thanks in advance
Rehana
I am using excel 2010 and have the problem of Consolidating my Data from 3 Sheets (image attached)
SheetV has got Data (Name1, Name2 etc) from E3 onwards (I have colored it red for sake of explanation)
SheetQ has got same Data (Name1, Name2 etc) from E3 onwards (I have colored it red).
SheetD has the names of the Dept (currently 30+)
I want a macro which should do the following consolidation for me. The macro should create the data as shown in the Result Sheet
Col A1 – Head1 which should copy the current year and month in the format yyyymm
Col B1 – Head2 which should copy the Data in Col B4 till last row from SheetV
Col C1 – Head3 which should map the Dept names from SheetD (eg. Name1 should be replaced with Dept1, Name2 with Dept2 and so on)
Col D1 – Head4 which should put the word CUR till down
Col E1 – Head5 this value will come from SheetQ (colored green for explanation)
Col F1 – Head6 this value will come from SheetV (colored blue for explanation)
The ID Column may also not have the ID numbers in same order (Please see SheetQ and SheetV)
The macro should allow to select the Range E3 onwards viz in the sample provided E3 to G13.
As the sample I have shown is for few rows and in reality it is 2000+ rows of data and 30+ names
Hope to get some help
Thanks in advance
Rehana