Copy specific number of rows to a new sheet

[trust_lord]

Hi,

I have a workbook with raw data. The raw data are on the 1st sheet consists of 200 rows and four (4) columns: 1st column-Branch Code, 2nd Column- GL Code, 3rd Column-Account Name, and 4th Column-Amount.

To easily manage the file, once i downloaded the data to my workbook, i.e., to first sheet, I want to automatically move the first 50 rows to 2nd sheet, the next 50 rows to 3rd sheet and so on. Headers are included.

Please help. Thank you

trust_lord

[JBeaucaire]

Try this:

Please Login or Register  to view this content.

[trust_lord]

Thank you, JBeaucaire for your quick reply.

It works fine. But what i wanted is to remove all the data from sheet 1. Sorry, I didn't mention it in my original post. How should i do it.?

[royUK]

It's much easierto manage data in one sheet. What are you doing that requires it to be split?

[trust_lord]

because i need to forward the file with 50 data only per sheet as required.

[JBeaucaire]

Change this one line:

Please Login or Register  to view this content.

[trust_lord]

It works great! Thank you so much.