VBA code to Copy entire row to new sheet multiple times

Hi

Im new here and to VBA and would appreciate some help. I have a set of data, and one of the columns named 'Steps', has single digit values eg 1,2,4,5 etc

I would like to copy each entire row to a new sheet. The number of times i would like to copy a given row will be whatever the number is in the steps column.

The size of the data set changes, so will need code to find the last row and then loop through the whole dataset to do the copying.

Your help is appreciated!

Cheer

Doable! Please attach a sample. Go to advance, then attachment.

Hi

Thanks for your response. This is a short example file attached.

cheers

Thanks. im assuming you renamed sheet1 "raw data" in your testing?

cheers

and apologies for the following newbie question.. why am i getting an "application defined or object defined error" when i try to run it?

cheers

Sorry! My bad!
I attached the wrong code and sheet name. Please see corrected attached post #4.

Thanks for your work on this.

however, sorry but im still getting an "application defined or object defined error" when i F8 through it, on the first line after "for i = 2 to LR".
Could it be my machine? its windows 7 with excel 2007

cheers

I re-run the code and did not get an error, so it is most likely that the error is on your data.

Did you get the error on the attached, or your actual sheet data?
Could it be my machine? its windows 7 with excel 2007
No, I do not think so. The error is on the code and we need to find it.

dies "Dim i&" mean Dim i as integer?

You still have not answered my question and seem we are going around the circle. Please attach the sample with a code which gives you the error.

hi, thanks for correcting but i cant see any code or modules in the vba editor? do i need to unhide anything?
cheers

Ooops,
You are right!
When I checked the attached, it appears to be macro saved, but there is no code on it. I have now double checked and has a code. It was one of those days.

Hi, thanks no problem. I have managed to modify it a little after you did the heavy lifting and it works. Basically, whenever it encountered a zero in the steps column, it crashed. I didnt want to bother you with a request to check for zeros (though u can show me code for it if its not too much trouble )
so i cheated by deleting all rows where a zero appeared.

Your help is very much appreciated! Cant thank u enough! Have a virtual pint on me. God bless.

Okay! I normally incorporate in my code for that purpose, but your were not luckily from the word go. The code was riddled with the errors.
I have now two codes for you(On the same module). The first one is the easiest way to cheat the error by including an error trap line, but it is not recommended.

The second code does not copy a row if the step column is less than 0.

Hopefully one of them works for you.