Insert Rows in Worksheet depending on Duplicate Entries in Another Worksheet

Hi,

I need to Insert Rows in a worksheet (sheet2) depending on the the number of times a value is duplicated in another worksheet(sheet1).

(Uploaded Pics)

This is what I want the Macro to do :
-> Count the number of time a value has been duplicated in Sheet 1 Column C .
-> Insert the number of rows (No. of Duplicate Entries - 1) in Sheet2 below the same value found in Column A Sheet2.
-> Copy and Paste the data into the newly rows from the original one above (Sheet2).

PS: The macro could also just 'insert copied cells' below the original row in sheet2 based on the number of times (minus 1) that the same value was duplicated in sheet1.

NOTE: The values in Sheet1 Column C are the same as Column A Sheet 2.

I appreciate your help.

Cheers,
JN



Uploaded with ImageShack.us


Uploaded with ImageShack.us


Uploaded with ImageShack.us