• 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.

How to create an abstract report from a table

K

kaushik

New Member
I have a table of data which contains daily vouchers and where the money went etc. Each transaction has an account code. Account code can be repeated, each of the transaction has voucher no which also can be repeated. End of month we need an abstract report based on account code. I tried pivot table, but I was not able to tweak it according to my needs. I am attaching the file which contains a sample data in one sheet, and abstract data format in another. Thanking you in anticipation
 

Attachments

  • Report.xlsx
    13.9 KB · Views: 5
Hi Kaushik,

I believe you were trying to retrieve data based on account code drop-down. Attached is the updated sheet. I was not sure how do you calculate total but I leave it to you.

Hope this helps.

Regards,
Anand
 

Attachments

  • Report.xlsx
    16.2 KB · Views: 8
rrocker1405 said:
Hi Kaushik,

I believe you were trying to retrieve data based on account code drop-down. Attached is the updated sheet. I was not sure how do you calculate total but I leave it to you.

Hope this helps.

Regards,
Anand
Click to expand...
So there is not a straight forward way for this in Excel. Isn't it? Well, Thank you very much for the help. I was thinking of using Access for the job
 
You must log in or register to reply here.
Back
Top