Results 1 to 3 of 3

Thread: Creating a report country wise

  1. #1
    Seeker gillani77's Avatar
    Join Date
    Jun 2014
    Posts
    14
    Articles
    0
    Excel Version
    office2013

    Creating a report country wise



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi ,
    I need to make a report on the pattern of sheet 1 attached. Can somebody help me in making that report? I am very badly struck up. I need to make this report after every 2 hours which is very difficult to make manually. I get work sheet 2 from sales department. This is auto generated sheet.
    I have 2 separate work sheets.
    1. Customer Order Book Sheet 1
    2. Order Progress Book Sheet 2
    I want to transfer information from Sheet 1 to sheet 2 as follow, automatically.
    From sheet 2 details of all orders of exporting country “Taiwan” (Column 2) for customer ID (905000) and Customer ID ((905009) should be written in Sheet “A” of work sheet 1. I need following detail from worksheet 2 to work sheet 1.
    Orders, Volume, Profit Percent, profit gain, fee, and partial cost and bank charges
    Then all orders of 905000 and 905900 from sheet 2 for all other countries (excluding Taiwan) should be written in sheet “A” of work sheet 1.
    Similarly, I want total of all orders from customer ID 911000 to Customer ID 911026 for exporting country “Dubai” should be transferred to Sheet “B” of work sheet 1. I need following detail from worksheet 2 to work sheet 1.
    Orders, Volume, Profit Percent, profit gain, fee, and partial cost and bank charges
    I have attached the work sheets both.



    I want to do for other sheets (C,D,E) of work sheet1.


    Attached Files Attached Files

  2. #2
    Just use SUMIFS formulas

    Tawain percentage: =SUMIFS('[Orders Progress Report.xls]Sheet 1'!$E:$E,'[Orders Progress Report.xls]Sheet 1'!$A:$A,B$2,'[Orders Progress Report.xls]Sheet 1'!$B:$B,B$3)
    Tawain volume: =SUMIFS('[Orders Progress Report.xls]Sheet 1'!$D:$D,'[Orders Progress Report.xls]Sheet 1'!$A:$A,B$2,'[Orders Progress Report.xls]Sheet 1'!$B:$B,B$3)

    and so on, I will leave you to work out the rest

  3. #3
    Seeker gillani77's Avatar
    Join Date
    Jun 2014
    Posts
    14
    Articles
    0
    Excel Version
    office2013
    Hi Bob , Thanks, I will try this formula.

    Quote Originally Posted by Bob Phillips View Post
    Just use SUMIFS formulas

    Tawain percentage: =SUMIFS('[Orders Progress Report.xls]Sheet 1'!$E:$E,'[Orders Progress Report.xls]Sheet 1'!$A:$A,B$2,'[Orders Progress Report.xls]Sheet 1'!$B:$B,B$3)
    Tawain volume: =SUMIFS('[Orders Progress Report.xls]Sheet 1'!$D:$D,'[Orders Progress Report.xls]Sheet 1'!$A:$A,B$2,'[Orders Progress Report.xls]Sheet 1'!$B:$B,B$3)

    and so on, I will leave you to work out the rest

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •