Insert rows and copy formula

[costin]

Hi all,

I have the code below for inserting a certain no of rows and copy the formula. From the selected cell it inserts and copy the upper row

What I would like to do and can't by myself due to my limited knowledge about VBA:
1. To automatically run the macro only if in column A I have "yes"
2. To copy the selected row (the one where is "yes" in column A) and to insert rows below it.
3. To replace all "yes" findings in column A with "no"

Thank you all for your help!

Please Login or Register  to view this content.

[arlu1201]

A few questions -

How many rows should be inserted below the row containing "yes"?

Also, you said

To replace all "yes" findings in column A with "no"

which findings? The current row which triggered the macro should be changed to "No" ?

[costin]

After the VBA will run, it will pop up a text pop where you can input the no of rows and it will insert that no. This is already done in the code I attached.

About that "yes" replacement: it should automatically run the macro only if in column A I have "yes". So, after the programming is finished it should replace that "yes" from A column which triggered the macro running.

To be honest, my point 3 is not that important. I'm interested more into my first 2 questions.
I'm very sorry cause I can't upload a sample, I'm currently at work and firewall doesn't allow me.