Excel Copy Paste

There are Job titles in COLUMN A.

There are a list of dates in COLUMNS G, I & K

There is information in all the rows between A, G, I & K

There is a list in COLUMN C which has either "completed" OR "not completed"

IF COLUMN C has "Completed" :


I am trying to write a macro does the following:


*Copies the data in the ROWs OF COLUMN A & COLUMNS G, I & K


*Pastes the data in a new row (20 ROWs down from the orginal ROW)
ONLY the data in columns A, G, I & K.


*Looks at the next row and does the same thing if the COLUMN C Cell for that row has "completed" - There are a total of 10 ROWS.