Code for inserting a row automatically based on a value in a particular cell

[keithjones33]

Hi all.

I have a spread sheet which is completed using production data. my issue is that when a machine runs more than 1 product only the info. for the one product is collected. What I want to do is enter a figure in column "E", its either going to be 1 or 2. If "2" is entered then I want to insert a new row below the row data is being entered into. Ideally it would also be good to copy the in info. from the cells in columns "A", "B" and "C" into the new row. I know this would have to be done using VBA coding but I have no experience of coding.

Thanks
​

 

[keithjones33]

Thanks for your input I will use the method described.

 

[My Aswer Is This]

Not sure what response worked for you sense there were more then one.
But:
Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

 

[DanteAmor]

Thanks for your input I will use the method described.

I'm glad to help you. Thanks for the feedback.