Hi All,
Hope can anyone help me with required code to complete my macro....
I have data in one sheet which has A to I columns and rows depends on the master data and it varies every time...Please note that in this data I have blank rows in between...some times like three non-blank rows followed by one blank row and other times 4 non-blank rows followed by 1 blank row....so, it varies from the input data to data...
My concern is that blank rows should be there because it gives me the segregation which will help in further reporting activities....
Requirement :
I would like to copy paste the every 100 line items into different sheet for example if my master data has 1000 line items then 10 work sheets should get create and paste the rows accordingly....It should create 10 sheets based on 100 line items. THE VERY IMPORTANT THING is if 99th row blank then it should not go beyond 100 and it should find the before/above non blank row end and should copy paste till there it self....
I don't want to get the in between data of non-blank rows....I need to copy & paste the exact set of data which contains 100 or less line items...
It is bit complicated and I hope explained in proper way....plz let me know if you need more example. ...
Hope can anyone help me with required code to complete my macro....
I have data in one sheet which has A to I columns and rows depends on the master data and it varies every time...Please note that in this data I have blank rows in between...some times like three non-blank rows followed by one blank row and other times 4 non-blank rows followed by 1 blank row....so, it varies from the input data to data...
My concern is that blank rows should be there because it gives me the segregation which will help in further reporting activities....
Requirement :
I would like to copy paste the every 100 line items into different sheet for example if my master data has 1000 line items then 10 work sheets should get create and paste the rows accordingly....It should create 10 sheets based on 100 line items. THE VERY IMPORTANT THING is if 99th row blank then it should not go beyond 100 and it should find the before/above non blank row end and should copy paste till there it self....
I don't want to get the in between data of non-blank rows....I need to copy & paste the exact set of data which contains 100 or less line items...
It is bit complicated and I hope explained in proper way....plz let me know if you need more example. ...
