I have a master sheet that contains a header and varying amount of rows. I need to export this sheet as a csv but cannot go over 101 rows (100 rows including the header).
What I am looking to for is a macro that takes the master sheet and breaks it into separate sheets and saves as csv, or only grabs 100 rows at a time and saves as csv.
For example, if my master sheet has 251 rows (250 rows and 1 header), I need to make 3 csv's. Two with 101 rows each (100 rows and 1 header) and one with 51 rows (50 rows and one header).
The header row will remain the same throughout.