Insert blank rows automatically - based on cell value

[parttime_guy]

Dear All,

Is it possible to insert blank rows based on a cell value

Attached below is a sample worksheet.

Kindly help.

Thanks and Best regards

[Bob Phillips]

Is the gap between the tables always the same number of rows, 10 rows?

[parttime_guy]

Dear xld

Thanks for showing interest.....

INFO sheet has 14 rows (this could vary).

In the Result sheet

14 rows to be inserted inbetween Row2 & Row3.
There would always be 3 rows in the table, below the header

The Information below the above table could vary (it should be intact).

Thx & BR

[Bob Phillips]

Sorry, didn't get anything from that explanation, just confusion:dunno

[parttime_guy]

After much search on the net and considerable mismash of available codes - I have solved my requirement - feels good !!! :)

In the attached file I have used the following (in order)

Delete rows
Insert rows
Insert Sr Numbers
Copy/Paste value in the result sheet

Hope the above codes are of help to users.
Thx-n-BR