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
bit refers to a tab that has a delay. eg the new row starts 1 hour after the initial "Area 1" row (see attachment)
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
Bookmarks