Hi all,

Im hoping you can help me out......

Anything more than recording a macro and Im way out of my depth!

I have a spreadsheet (when I try to upload it says its corrupt)

A - B - C
1 Loosen wheel nuts - Operator -
2 Jack up car - Operator -
3 Inspect jack up - Inspector - Random
4 Remove nuts - Operator -
5 Remove wheel - Operator -
6 Inspect removal of wheel - Inspector - Random
7 Replace wheel - Operator -
8 Replace nuts - Operator -
9 Lower car - Operator -
10 Tighten nuts - Operator -
11 Inspect tighten of nuts - Inspector - Mandatory



Where a random inspection occurs (ie row 3) I want to insert a line and copy the row row above, so that it duplicates the inspection. Where a mandotory inspection occurs I dont want anything to happen.

Is this even possible as when I record a macro it remembers the row number each time so when I have a different sequence, it inserts the row at the wrong point.

Thank you for any help
Alex