Help with code to copy cell to another sheet based on Criteria

[rv02]

Dear All
I was wondering whether someone can help me with the following problem:
I have attached a simple spreadsheet to demonstrate what I need to do:
In the attached spreadsheet I need to look in sheet1 and if the scores in Col G is greater than zero then to copy the company name for that many times in sheet2 column A.
For example Company Aa in sheet 1 has scored 1 so AA needs to be copied once in sheet2 A2 only once. Then company BB’s score is 2 so BB needs to be copied in sheet2 starting from first blank row in column A (i.e. A3), and CC to be copied 3 times to Sheet2 col A first available blank row (A5 , company DD should not be copied as it has score 0 and EE should be copied 5 times as it has score of 5 in Sheet 2. I just want to copy the company name and not the whole row.

Hope this makes sense.

Thanks in advance

[xladept]

Try this:

Please Login or Register  to view this content.

[rv02]

Thank you so much. This worked perfectly

[xladept]

You're welcome and thanks for the rep!