Hi,
I have a master worksheet having 10,000 rows and I want to split the entire 10,000 rows in multiple sheets, but each sheet should contain maximum of not more than 850 rows.
So, when I run the macro it should create the sheets in the same workbook.
So in the above example 10,000/850 = we get 12 sheets.
it should take first 850 rows, then 851 - 1700 and then 1701 -2550 and so on and the last sheet might get the available remaining rows only.
Would be great iof any one finds a idea how this can be done with a vb code. I am learning now, if I get let you know.
Thanks,
M