Split data into multiple worksheets based empty row

[calvinle]

I have tried to split using KuTool and ASAP Tool but they dont work. They can only split base on #of row. Between each of the group of my data, there is a empty row that split them. I want to split every single row from A:H to a new workbook. Why A:H becuz from A1:A8, the A5 is empty. It has to be in range, specify by me, so if the condition is met as empty from A:H, then split from there and keep going on the whole spreadsheet.

Please help...

[rbs_logesh]

Try this

Please Login or Register  to view this content.

[FDibbins]

rbs_logesh welcome to the forum

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I will add then for you - this time

[calvinle]

Try this

Please Login or Register  to view this content.

Hi, the code looks great, however, once the data changes from 5 rows to 6 rows, it will split them too, which it mess the data.

I have attach the excel to this, with the result, it suppose to create 4 different worksheet, as you can see the empty row between them.
dasd.xlsx

Also, it is possible to have the worksheet name pull from the "2nd row of the 6th colum of each worksheet?" Like AVA, IVA, OLA, RADA in this attachment example.

Thanks.

[Naveed Raza]

Try this the attache file

just open the file & press Alt + F11 and run the macro

hope this will work

[calvinle]

Wow great!! Thank you very much. I will try to figure out to rename each worksheet by reference on a cell. Thanks again!

[Naveed Raza]

Hi Calvinle

Glad i could help you

1) If the suggestion helps you, then Click * to Add Reputation & mention your valuable comments
2) If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

[fuudin]

Can it be split like this?

Workbook A (Sell)
Item Code Item name
001 2287
001 2296
002 411EA
001 412EA
002 2287

Workbook B (Buy)
Item Code Item name
001 2389
001 2411
002 413EA
001 12EA
002 2481

To become like this with different worksheets same workbook:

001 Item code(sheet1)
SELL TABLE
2287(sell table) (col for formulation)
2296(sell table) (col for formulation)

BUY TABLE
412EA(buy table) (col for formulation)


002 Item code(sheet2)
SELL TABLE
2287(sell table) (col for formulation)

BUY TABLE
413EA(buy table) (col for formulation)


If new item code exist it will go to another sheets. The buy table item code always have EA.
Please help me

[arlu1201]

fuudin,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.