Hi,

I have a large excel database that needs to be cut into separate files based on the row. 25% of the values need to go to one file and 75% to the other (so counting down the list, rows 1, 2, 3 will stay, 4 will go to an alternate spreadsheet, 5, 6, 7 stay, 8 goes, etc)

Anyone know an easy way to accomplish this?

There are more than 10,000 rows so select/copy/pasting every 4th row is unfeasible BTW

Thanks