Auto unhide one row --- OR --- Auto insert one row

[Bkisley]

I need to show the following and I can not figure this out!

Scenario 1
I have row 10 filled with data up to column O
I have rows 11-24 hidden
This 15 row set up is copied down 50 times so the below process would need to be repeated in each of those 15 row sets
If column O has a value >0 than I need row 11 to unhide while keeping rows 12-24 still hidden.

To help visualize this
row 10 component name and initial manufacturing process
row 11-24 component secondary manufacturing processes - initially hidden then for each value > 0 in column O one row at a time is unhidden
row 25 component name and initial manufacturing process
row 26-39 component secondary manufacturing processes - initially hidden then for each value > 0 in column O one row at a time is unhidden
and so on....

I don't want 15 rows showing for every component when some components may only have one or two processes


Scenario 2 is less desirable but I could work with it
The same story as above, however rows are not hidden

I have row 10 filled with data up to column O
If column O has a value >0 than I need a row inserted below row 5


PLEASE PLEASE HELP!

 

[Bkisley]

Re: Auto insert row after typing in a certain value

Wow this worked like a charm! I'll play with it more tomorrow and see if this checks all the boxes. Fantastic job though

Much appreciated

 

[Bkisley]

Re: Auto insert row after typing in a certain value

The only thing I would like to add, if possible, is automatically carry down the equation from B or RC-2 from the code above. Is this possible??