• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

macro for sort out details from data

J

jack999

Member
Sirs, I would like to sort out and copy each party's sum of sales, cash received, cheque received, discount given, goods return etc. in a new sheet. Sample file attached. Can somebody give a solution
 

Attachments

  • AC-Statement.xlsx
    36.9 KB · Views: 9
Hi Jack,
Are you looking for a formula-based solution (where you may need to add more data rows periodically in the "new" sheet, or are you looking for a VBA-based solution (where the operation could be more automated)?
 
Sajan said:
Hi Jack,
Are you looking for a formula-based solution (where you may need to add more data rows periodically in the "new" sheet, or are you looking for a VBA-based solution (where the operation could be more automated)?
Click to expand...
I need a VBA solution for do that
Each party and its relevant sum showed in separate column
party name Bill Amount Cash Received Cash Transfer Discount Given Credit note etc...
 
Hi Jack,
I am sure one of the other members will help you with a VBA solution, since that is not my forte.

Could one of the forum Ninjas move the post to the "VBA" section, to ensure it gets the attention of the VBA folks?
 
@Sajan
Hi!
You're welcome.
Regards!
PS: I just happened to work on this topic... :cool: moved all the posts, character by character to this forum... :p hard job... :D now I'll rest for a while... :rolleyes: while I wait & hope someone else faces this issue... o_O
 
Hi, jack999!
It works so smooth the file that you've uploaded that I'd feel guilty if I happen to write a piece of VBA code to replace those so good formulas. Are you sure you want to spoil and delete them and replace for a macro?
Regards!
 
SirJB7 said:
... now I'll rest for a while... :rolleyes: while I wait & hope someone else faces this issue... o_O
Click to expand...
@SirJB7
Hi, myself!
So long...
Like me you'd be wondering where is hidden that "someone", don't you?
It's a coward... :mad:
Regards!
 
SirJB7 said:
Hi, jack999!
It works so smooth the file that you've uploaded that I'd feel guilty if I happen to write a piece of VBA code to replace those so good formulas. Are you sure you want to spoil and delete them and replace for a macro?
Regards!
Click to expand...

Sir I don't want to delete the formula sheet. I need macro for other purpose. As in the sheet1 of uploaded workbook, I need Total of Invoice amount, Total of Cash received, Total of Cash Transfer, Total of Discount given, Total of Credit note for Each party.

In the requirement sheet there is showing (detailed) each transaction . I need macro for summing of each parties particular transaction.

Thanks and Regards
 
You must log in or register to reply here.
Back
Top