Inserting multiple rows below an exisitng row and copying and pasting that data

Hi everyone,
This is my first question on the forum so please be gentle with me!

I need to create a macro that is similar to ones that I've seen on this forum - I want it to insert rows below an existing row of data and then copy and paste data from the existing row into each of the new empty rows. However, the number of new rows required is determined by the number present in a certain cell (F1) of the existing row. So if the number in F1 is 5, then I need the macro to insert 4 new rows and copy and paste exactly the same data, resulting in 5 rows containing exaclty the same data. Then I want the macro to move on to the next unique row and repeat the process. But if F1 in the next unique row = 1, then I want the macro to ignore that row and move on. In the worksheet I'm using the number in F1 changes for every row. I need the marco to go through a worksheet with about 1000 different rows.

I hope that makes sense?

I've attached an small example of the worksheet I'm using. There are 2 tabs, the first tab called 'data' is the raw data, the second tab called 'sorted' is basically what I want the macro to do.

Any help/tips would be greatly appreciated.

Here is what you need:

Please Login or Register  to view this content.

Don't forget to click on the Star below the posting to show your appreciation for the help received and mark the posting as solved.

Hi there,
Thanks so much for the macro, it looks great.
I ran it on some data but got the following error message:

Run-time erro '9':

Subscript out of range


I've attched the worksheet that I was trying to run the macro in. I've got no idea how to fix the error, sorry!
Any further help would be greatly appreciated.
Cheers

You must name your sheets "Data" and "Sorted" not quote marks or change the code to suit your naming convention of the worksheets.

Don't forget to click on the Star below the posting to show your appreciation for the help received and mark the posting as solved.

Hiya,
Thanks for that. I renamed the sheets and the macro does now work, except that it kind of crashes excel. It goes through the data but when it gets to the final row excel freezes and comes up with the 'Not Responding' warning and the spinning wheel of death. When I shut it down using the Task Manager, excel sometimes restarts and the sorted data is there, and sometimes it's not there. I've tried running it on another machine running windows 7 and excel 2010, and also on a mac running excel 2011 and the macro crashes excel on both those machines too. Not sure why or what to do. It seems like it's really close to working. Sorry to keep hassling you!

It's now working like a dream.
Thanks so much fpr your help!