I'm not sure if this is the right place to post this, but I'm stuck. I have to create a Macros that allows you to give a line number, it takes all the values in that line and pastes it into another sheet, then it goes back ans starts from the line after that and copies over 15 lines at a time until it runs out of lines. Can anyone guide me in the right direction?

Thanks,
-Seyed