macro to copy rows based on number in column

Hi,
I am new to the forum and a stranger to Visual Basic. I have a worksheet in Excel 2010 that has rows like this:

PLANT TYPE COLOUR PRICE NUMBER
Achillea kamtschatica gr cover pink $2.00 1
Agastache perennial blue $1.00 3
Ajuga gr cover blue $1.00 2

I have to print labels for a charity plant sale with the name of the plant, type, colour, and price on each label. The number of labels for each plant is given in the NUMBER column. I would like to have a macro that will copy each row just the number of times that is specified in the NUMBER column, so that after the macro runs, the worksheet will look like this:

PLANT TYPE COLOUR PRICE NUMBER
Achillea kamtschatica gr cover pink $2.00 1
Agastache perennial blue $1.00 3
Agastache perennial blue $1.00 3
Agastache perennial blue $1.00 3
Ajuga gr cover blue $1.00 2
Ajuga gr cover blue $1.00 2

I would be enormously grateful if someone would send me a macro script that I could paste into Excel's macro editor.
Thanks in advance!
Arthur

Hi
Can u provide the sample data in a better format?
Cannot differentiate between PLANT and TYPE...

Hi
Try this macro. I hope this solves ur prob:
DATAREPEATATION.xlsm


Regards...

Dear jraj1106,

Thank you for the macro. It worked perfectly. Some day I would like to take a course in VB so that I could understand why it worked! But I so rarely need to use a macro that I shall probably rely on generous people like you to provide me with what I need.

I am sorry for the poor formatting. When I posted the message all the extra spaces that I inserted in the composition window disappeared. I will know better next time.

I see that your location is Mauritius. I hope you are enjoying a pleasantly sunny day.

Arthur

Hi
Thanks for your feedback. Pls click on the star below your post.
Sure, any probs in future I can help you out.
Thanks again...

Regards..

If any friend can help me in my following thread.

Automatic Check box insert against each filled row