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

Creating a report

gillani77

New Member
Hi ,
Requirement1

I want to transfer following information from sheet 1 to sheet 2, automatically. The following information required for total orders sent to Dubai for Customer ID 911000 to 911026.
Orders
Volume
Profit Percent
Profit gain
Fee
Partial cost
Bank charges
Requirement 2
Then Following information from sheet 1 to sheet 2 to for all countries less Dubai for customer ID (from 911000 to 911026) should be transformed.
Orders
Volume
Fee
I have attached sheet.

Looking forward for help.
 

Attachments

  • Report.xlsx
    58.1 KB · Views: 4
Hi Somendra,
Thanks for your help.
I request you to explain me this formula as, I need to make this report twice a day.
I saw you have mentioned "TABLE 1" in your formula but I could not find any table in this excel.
I put customer ID just as an example. I have to made this report for some more Customer ID like (from 906000 to 906380), (918000 to 91060), (92000 to 92070).
Therefore, if you explain me all this procedure , it will help me to avoid preparation of this report manually.
Once again thanks.
 
Back
Top