"Copy data from single sheet to multiple sheets

I recieve a daily spreadsheet with ~25,000 rows of data and is 4 columns wide.

Each day I need to break the data equally up into 19 or 20 different sheets within the same workbook. This is very time consuming as I need to copy the first ~1,000 rows and paste it into the first sheet, then I need to take the next ~1,000 rows and paste it into the second sheet, and so on.

Since i dont not know much about VBA code.It would be great if example workseet is attached with VBA code with your answer.

If the Split is every 1000 rows and 4 columns, this is quite simple, but I guess that there must be another criterium that determined the # of rows. Could you please specify that criteria, or is is every 1000 rows?

... and what should be the new names of the sheets e.g. 1-999, 1000-1999, etc.

Try this:

Please Login or Register  to view this content.