Split data are existed in two sheets to two sheets for each group

[abdo meghari]

Hello,
I would macro to deal with about 10000 rows and contain about 100 groups for each sheet.
in SELLING,BUYING sheet should split data based on column B for each group ,as to column C should match with sheets names(SALES,COSTING) are already existed and show data for each sheet based on sheet name is existed in column C for SELLING,BUYING sheets.
split data if the C3,E3 are empty in SPLIT sheet, otherwise when there are dates then split within dates in C3,E3 in SPLIT sheet.
CROSS POSTED
https://www.mrexcel.com/board/thread...3#post-6247166


thanks in advanced.

[JohnTopley]

Please Login or Register  to view this content.

[abdo meghari]

thanks John .
sorry about error in year for SELLEING sheet. this spotting told me by Alex Blakenburg in other forum.
just I need fixing numbers in ITEM column should be 1,2.... I see showing all of elements contain 1.

[JohnTopley]

Oops .. see attached

[abdo meghari]

Thank you so much.

[abdo meghari]

hi John again.
I notice populating SELLING PRICE , SELLING TOTAL in COSTING sheet instead of COSTING PRICE , COSTING TOTAL in column F , may you fix it please?
sorry this is my bad!

[JohnTopley]

See attached

[abdo meghari]

thank you so much again john .