Insert row if efficency improvements

Hi Everyone,

I hope you are well.

I have a spreadsheet with a macro that inserts rows when a condition is met. Im using the code below to look for "Area 1" and insert a row underdeath with the text "Area 1 - Collect Item". The

Please Login or Register  to view this content.

bit refers to a tab that has a delay. eg the new row starts 1 hour after the initial "Area 1" row (see attachment)

Please Login or Register  to view this content.

This works fine but I have around 75 of these now which is starting to create a processing issue.

So....three questions!

1. Is there a more efficient code I could use for this?

2. I have a list (see example) would it be possible to say something like.....
If A2
Then input B2
And add delay C2?

3. Could extra line items be added to the table and these be automatically picked up as part of the macro?

Thank you for any help you can offer
Alex

Any help to any part of the question would be greatly appreciated!