Hi

i am somewhat new to true vba - as apposed to recording macros.. but i think i need some help here.

Basically in one certain column on my excel spreadsheet i have certain words eg "Son" and in other cells in another column, not necessarily on the the same row which say something like " yes-pp".

what i would like to do is the following:

First off i need to find the first cell in the column which contains "Son" which in this case is cell "g3" - but this can vary, then i need to look at the row above that one and 10 cells forward to see if it contains "yes" (now the data in the 'yes' column can say; yes-cc/ yes pp - basically has a few variations but as long as it says yes and son i then i would like to insert a row below the row containing "son" -

After that i want to type text in the cell underneath "Son" eg "Boy"

Data looks something like this:

yes-pp
son
age

So i need to insert a line between son and age and for it to write boy.

please if anyone can help i would really appreciate it

this has been driving me up the wall

I would very much appreciate if you could also put comments near the code to explain what is being done so i can learn from this experince

Much appreciated

Silver