VBA; copy paste number of times based on cell value

hi everyone,

I am hoping you can give me a hand with what I would like to accomplish. I've been able to figure out several things through browsing the forums, but I am unsure how to accomplish what I want to do here.

I would like to copy the X, Y and Z Coordinates into a new sheet, but I would like it to be copied the number of times in the relative area x 10. For instance, in the sample data sheet, Row 2 is copied into the Matrix sheet 6 times (relative area = 0.598*10). Row 3 values are copied four times.

On the Matrix sheet, I need for each fish and each side, there to be 25 allotted rows. Any values left blank are filled in with zeros. So in my matrix sheet, there are 25 rows for one fish and one side, and any of the empty rows were filled in with zeros.

There is a messy macro to fill in zeros in my sample spreadsheet, so feel free to disregard.

I have several data sets to do this, so the number of fish will vary from dataset to dataset, and manually copy pasting will simply take to long.

My sample dataset is at the following url:
http://www.speedyshare.com/files/264...PhotoPidge.xls

Thank you in advance for any suggestions!

Cheers
pidge

Solved here: http://www.ozgrid.com/forum/showthread.php?t=150099