Hi
I have looked into some posts about copying range of rows with another sheet row but did not find a suitable one.
so, here I am trying to copy a each row from sheet1 with a range of rows from sheet2 and copy into new workbook.
Like, 10k range rows with 100 rows will become 1 million rows. Like that, for every 100 rows with 10k range, I want to split into different workbooks.
In Sheet2 I have 170k rows and in sheet1 10k range rows.
I think it is possible with VBA do this task.
I have looked into some posts about copying range of rows with another sheet row but did not find a suitable one.
so, here I am trying to copy a each row from sheet1 with a range of rows from sheet2 and copy into new workbook.
Like, 10k range rows with 100 rows will become 1 million rows. Like that, for every 100 rows with 10k range, I want to split into different workbooks.
In Sheet2 I have 170k rows and in sheet1 10k range rows.
I think it is possible with VBA do this task.