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

collection report

V

vishwas

New Member
Hi,

I have attached an excel file which has 2 sheets ;Overview and data. Data has details of collections received at different collection centers. Collection mode is either cash or cheque. Overview sheet shows the desired expected output. User should be able to select all the 3 options i.e date, payment method and cashier as a drop down in the report. Other details in the body of the report should be automatically displayed. I kindly request for help

Thanks
 

Attachments

  • Daily collections report.xlsx
    34 KB · Views: 5
Please see the temp solution :)

vishwas said:
Hi,

I have attached an excel file which has 2 sheets ;Overview and data. Data has details of collections received at different collection centers. Collection mode is either cash or cheque. Overview sheet shows the desired expected output. User should be able to select all the 3 options i.e date, payment method and cashier as a drop down in the report. Other details in the body of the report should be automatically displayed. I kindly request for help

Thanks
Click to expand...
 

Attachments

  • Copy of Daily collections report.xlsx
    37.9 KB · Views: 7
You must log in or register to reply here.
Back
Top