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

sales summary report

jack999

Member
Hi

Can some one help me to make month wise summary report under each customer as the report sheet in sample sheet with macro . I will be very much thankful to you.

Please look into this problem and give a solution


Thanks in advance
 

Attachments

  • customer.xlsx
    14.5 KB · Views: 5
Thank you very much for your help. But I also expecting a macro solution for this because in my original date some invoice numbers are missing and it should take from delivery date as shown below. Is that possible kindly help me. If column C dates are missing it should take from A Can some one do it for that same as pivot table report.

Column A ColumnB ColumnC
RECEIVED
DESPATCHED
DATE
INVOIVCE
NO

INVOICE
DATE
CHELLAN
NO
11/05/19562221852511/05/19
562221853518/05/19
22/05/19562221858522/05/19
23/11/18562221852317/11/18
01/03/19562225166727/02/19
11/02/19562293824311/02/19
07/03/19562293826201/05/19
28/11/18CH.1708
28/11/18CH.1709
TAB/1819/2521/12/18




Thanks
 
Last edited:
Shall I get all customer details in one page as per your pivot table. How will check each customer address in the Address book

Your given site not showing as per my choice of output sir.
 
Last edited:
You can modify the codes as per your requirement.

Select all like shown in below screenshot, you get all customer & address details in given pivot.
61104
 
If we select all customer it does not show each customer name. only shows all quantity. I would like to have all customer name also with quantity is it possible.

Sir, I am not expert in vba to modify as per my requirement
 
Thanks for your reply I needed with month,customer name, items, quantity and total as on the sample file, screenshot. That is why I requested for macro.
 
Last edited:
CAN SOMEONE HELP
Array Formula for copy value from Data2 to report
column ABC I HAVE ALREADY FILLED

IN SHEET1 D5 NEED FORMULA Sheet1 B2 NAME=SHEET2 RAGE C:C AND SHEET1 F:F RAGE VALUE=PURCHASE OR SALES RETURN THEN VALUE COME IN D5 COLUM (INWARD)
IN SHEET1 E5 NEED FORMULA Sheet1 B2 NAME=SHEET2 RANE C:C AND SHEET1 F:F RANGE VALUE=SALE = OR SCHEM, FOC THEN OUTWARD
 

Attachments

  • Dummy.xlsx
    21 KB · Views: 8
Back
Top