if else loops excel vba code required

looking for some vba excel code that does the following

document 2 worksheets

sheet 1 called "master project register" which has hundred rows (project names) and 6 columns named as follows

column a = project name
column b = segement
coumn c = date
column d = go live
column e = project close
column f = live project

sheet 2 is called "import to project " and has only the above headings from column a to f

i want to do the following in excel for each row in master project register worksheet

1. if column F = Yes
than do the following

note if doesnt = yes than move onto next row etc


2. copy row and paste into "import to project " workseet
3. ihighlight row 2 and insert2 rows directly beneath the pasted data.
4. in column a in first empty row in cell a2 write " go live"
5.in column a in second empty row in cell a3 write " project close"
6. copy the segment name down from b1 into b2 and b3

7.copy d1 into c2

8.copy e1 into c3

9. highlight row 1 and insert empty row ( ready for the next set of data to be inserted)

the above code will repeat steps for every project in the master worksheet looking for any "yes" in column f and repeating steps 2-9

appreciate your help guys.... im sure this is achievable....

if anyone knows also how to write message at end to say " you have pasted x number of projects"

x = projects with "Yes" in column F

So what have you tried so far? Attach an example workbook.

You can attach a file by clicking "Post Reply" then scroll down until you see the "Manage Attachments" button