I hope the title is proper as I do not know the right subject for my query.
One of my employee has made a data as shown in sheet1, (although the data is very long this one is a brief one)
Brief description of data is as under
Colomn A has the serial number mentioned 1, and for column F there are types mentioned from a to i, and column B to E has just one entry in row 8. This means all the types mentioned in column F from a to i have the same values that are given in column B to E.
Then there is a space in row 17.
Next
Colomn A has the serial number mentioned 2, and for column F there are types mentioned from a to b, and column B to E has just one entry in row 18. This means all the types mentioned in column F from a to b have the same values that are given in column B to E.
Then there is a space in row 20.
Same for serial numbers 3, 4 , 5 , 6
What I need to change is
For Serial number 1 and data for B8 : E8 should be copied till row 16
For Serial number 2 and data for B18 : E18 should be copied till row 19
same for serial number 3 , 4, 5, 6.
The blank rows in 17, 20, 23, 27, 31 should be removed.
The list is very long and as the employee who has made this is on leave it becomes very tedious to manually rectify the data.
Is there any VBA code for this.
The data would look somewhat as in sheet2
The serial numbers are just mentioned for easy reference and is not present in actual sheet.