consolidation of rows with similar information

[rsp1]

Hallo I need some help and I hope that samoone can help me. In the file "example" in "sheet 1" we have information about elements in rebar workshop. In "sheet1" column "s" we have some numbers (1,2,3,4,5.....) this numbers show the elements (every row that has "1" in column S means that this row contain same element ). The difference in the rows with same elements are in columns "F" where is shonw number of the same elements. My idea is for macros that first: filters the rows by the information in columns S, second: sums the numbers in column F, third:writes the sum of numbers in the first of the rows with same elements, fourth: deletes the rows with same elements except the first one where we wrote the whole sum and finally when we have done these things there will be a lot of empty rows, so the information have to be copy(no cutting) and pasted that there are no empty rows. In the file "final" there is what have to look like finally. Can someone help to me?

[rsp1]

sorry to ask again but nobody can help?

[AliGW]

76 views and no help offered suggests that your request is not clear. Maybe try restating it? There have also been 12 views of the attachments, which suggests that they are not as illuminating as they might be.