Data Split customer wise

[Shabbo]

Dear Sir,

Reference to attached sheet, I wanted to split the data into different sheets with customer wise and email id’s should come on A1 column of each customer.

Please advise.

 

[vletm]

Shabbo
Press [ Do It ]-button and ... wait a moment
(I didn't test all sheets ... and I take that C-column is Your 'Customer')

 

[Shabbo]

Dear Sir,
It worked perfectly can you please add, total column.

 

[vletm]

Shabbo
Where?

 

[Shabbo]

At last column " Column" C should be written Total and D column Calculate Total.
Also Voucher number, Date, Customer name Balance, and days should come to row number 2 and transaction should start from row number 3, in this case heading voucher is missing because heading starts from Column A and Transaction starts from Column 2.
Please refer sheet number 3 "S PVT LTD." I have given example of the way I wanted if possible please do that way including colors.

 

[vletm]

Shabbo
Your file had some challenges - not good file!
but
I tried to figure Your 'total column' ...
I added those to below of the last row with colors.

 

[vletm]

Shabbo
You sent about 50minutes ago that there were some challenges ...
Do it work or something else?

 

[Shabbo]

Its working now sir. thank you so much.