Help needed: Copy cells down x amount of times based on search results

[Mattrick2oo3]

I'm currently working on a spreadsheet that will import data from an existing spreadsheet into a new template file. I have the code written to import and format all the cells but need help with copying cell contents. I need to write a macro that will read the contents of Column "G" for "4 X" and copy the information in Column "A" and Column "D" down to the next 4 rows. I need it to loop through the entire spreadsheet until it can no longer find the specified value in Column "G".

See below.

Char Num			Bub Num			Req
1			1			4X
						200
						200
						200
						200

<tbody>
</tbody>

Need "1" in both Column copied down to the next 4 rows.

Thanks,

-Matt

 

[Mattrick2oo3]

bump