Macro that copies every 600 rows and paste data in new spreadsheet

I am trying to write a macro that will copy data stored in every 600 rows to a new spreadsheet - i have tried to upload a trimmed version of the spreadsheet but the up loader is not working for me!

The spreadsheet contains 450,000 rows of data; column A is time, column B is signal response.

i would like to write a macro that copies every 600 rows of data (A1:B600, A601:B1200, A1201:B1800, etc) to a new spreadsheet tab.

For example:
sheet 1 - select A1:B600 (copy), sheet 2 A1 (paste)
sheet 1 - select A601:B1200 (copy), sheet 2 C1 (paste)
sheet 1 - select A1201:B1800 (copy), sheet 2 E1 (paste)
ect....for every 600 rows until all data is copied.

I have limited experience with excel macros - the only way i know how to do this is by writing code for action. I was hoping that someone could help write code that is more automated

thanks in advance

Would something like this do it (Try on a copy of your workbook)

Change "Sheet2" in this code to the Sheetname with the 450,000 rows of info

Please Login or Register  to view this content.

Thanks Paul- the macro you wrote worked a dream....I must say the code was more complicated than envisaged, especially for a macro novice like me.

I am now looking for a macro to calculate the median of each column, then subtract the median from each data point within the column and present the new data points in a third spreadsheet....can you give me any pointers?

Again - your assistance is much appreciated