Hello everyone
I have two sheets .. the first is for raw data which is needed to be formatted in specific way
Sheet2 is the result sheet .. I will explain what is fixed and what is to be changed
In sheet2, the cell M2 I will put a value from sheet1 column D (Here's as example 1 or 2) suppose I type 1 in M2
The headers from rows (5 : 10) to be copied again but there after the first group data with five rows (five blank rows in between the two groups)
As for headers the colored cells will be changed :
** J5 & J26 will be the same value as M2
** K5 will be the string "A's Group" & K26 will be the string "B's Group"
** L5 & L26 will have the total of results (as explained in the attachment)
As for the data it will not be exactly as the raw data .. notice the columns positions
and as for the column A in sheet 1 is just numbering and in the result sheet I need to number filtered data
NB : The data would be put after the header but let blank row as illustrated
Hope it is clear and easy
Thanks advanced for help
Bookmarks