hi experts
I know what I ask for it . it's very complicated . so in sheet INPUT I have data and repeated based on column B in this case should split data for each customer based on column B as I put some result data in sheet OUTPUT. when split data . it should be empty break line among tables whether column or row and the column C in sheet INPUT should split into cases as in sheet OUTPT depends on words(INV,VC).
and start three tables from the beginning and copy to the bottom until finish based on data in sheet INPUT when create the tables for each name should based how many data for each name based on DEBIT, CREDIT , if it's one of them contains filled cells more ,then the other then it will create cells based on how many DEBIT OR CREDIT contain cells . see CUS-PAA1,CUS-PAA2,CUS-PAA3 they change in how many cells . finally I put some formulas how should calculate . but I would show as value .
if anybody interest to help me jut tell me if need for more details
Bookmarks