VBABEGINER
Well-known Member
- Joined
- Jun 15, 2011
- Messages
- 1,284
- Office Version
- 365
- Platform
- Windows
Hi All,
I need assistance in entire code please..
It's easy to make the code b'coz, formats of the sheet are same..
I have 7-8 sheets. I want all data combine in single sheet..
Format of sheet like below--
Columns A, B, C, D & E are merged from row 2 to 24. i.e 23 row's.
Column F contains, region names which are fix 23.
From Col G, my monthly data starts. Like,
Col G - Jan'18
Col H - Feb'18
Col I - Mar'18
Col J - Apr'18
Col K - YTD'18
Col L - Comments
Now, Sheet1 person only have one metric data hence data is onlt till row 2 to 24. (Fix)
Sheet2 person also have data row 2 to 24, as only have one metric data.
Sheet3 person have 5 metric data hence rows grouping like this..
2 to 24
25 to 47
48 to ....and more..
So, all this data gets combine in one sheet..
Can anyone help on this..
I need assistance in entire code please..
It's easy to make the code b'coz, formats of the sheet are same..
I have 7-8 sheets. I want all data combine in single sheet..
Format of sheet like below--
Columns A, B, C, D & E are merged from row 2 to 24. i.e 23 row's.
Column F contains, region names which are fix 23.
From Col G, my monthly data starts. Like,
Col G - Jan'18
Col H - Feb'18
Col I - Mar'18
Col J - Apr'18
Col K - YTD'18
Col L - Comments
Now, Sheet1 person only have one metric data hence data is onlt till row 2 to 24. (Fix)
Sheet2 person also have data row 2 to 24, as only have one metric data.
Sheet3 person have 5 metric data hence rows grouping like this..
2 to 24
25 to 47
48 to ....and more..
So, all this data gets combine in one sheet..
Can anyone help on this..