+ Reply to Thread
Results 1 to 10 of 10

Adding Information to a Daily Report

Hybrid View

  1. 01-04-2013, 12:27 PM #1
    Sally Rose
    Sally Rose is offline
    Registered User
    Join Date
    01-04-2013
    Location
    Manchester
    MS-Off Ver
    Excel 2007
    Posts
    26

    Adding Information to a Daily Report

    Hi there

    Please can someone help with a daily report I have to create.

    On a daily basis I will be provided with dispatch information from a warehouse. What I need to do is create some sort of report that will add the data and then calculate totals on a daily basis. There are five columns on the daily report that I will be provided with but I am only interested in two colums: that is the product code and the quantites. I will then save under a week number or month.

    Hope that makes sense!

    Thanks

    Sally
    Last edited by JBeaucaire; 01-04-2013 at 01:36 PM. Reason: Corrected thread title to topic only, as per forum rules
    Reply With QuoteRegister To Reply
  2. 01-04-2013, 12:39 PM #2
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,610

    Re: HELP PLEASE ! Adding Information to a Daily Report

    Hi
    something like a Pivot Table perhaps? Without seeing your data it's just a wild guess
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
  3. 01-04-2013, 12:51 PM #3
    Sally Rose
    Sally Rose is offline
    Registered User
    Join Date
    01-04-2013
    Location
    Manchester
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: HELP PLEASE ! Adding Information to a Daily Report

    Hi Gura

    Please see below. I just want to calculate on a daily basis the UPC and relavant quanties.....



    Daily Despatches by Product

    Report last refreshed on 03/01/2013 07:05


    Axida Despatches

    UPC Units Quantity Delivered Date Order Number Customer Name
    1519136 1 02/01/2013 009/44731 MR S SUDRA
    1519136 1 02/01/2013 009/44731 MR S SUDRA
    5177561 1 02/01/2013 0078182476 MISS A MAKIN
    8595676 1 02/01/2013 0077991013 K STUBBINGS
    6038885 1 02/01/2013 0077721304 MR J MUIR
    7675300 1 02/01/2013 0077721304 MR J MUIR
    9157927 1 02/01/2013 031/13911 MRS FM MILNE
    9164109 1 02/01/2013 031/13911 MRS FM MILNE
    9287136 1 02/01/2013 0078258279 MRS J MCWILLIAM
    9299450 1 02/01/2013 0078258279 MRS J MCWILLIAM
    4840589 1 02/01/2013 0078409115 MISS K FITTER
    4774211 1 02/01/2013 0078376051 MRS V PERCIVAL
    3472224 1 02/01/2013 009/44755 MR S HEATLEY
    3361313 1 02/01/2013 647/44312 C STANNARD
    6396961 1 02/01/2013 0076575549 MRS C VICKERMAN
    7718182 1 02/01/2013 802/02825 F JOKIC
    4904861 1 02/01/2013 104/04612 MRS SC WOODHOUSE
    4904892 1 02/01/2013 104/04612 MRS SC WOODHOUSE
    8194794 1 02/01/2013 407/10218 MR & TL RANN
    4889762 1 02/01/2013 005/42030 MRS M MURRAY
    2730677 1 02/01/2013 0077991013 K STUBBINGS
    1487527 1 02/01/2013 009/44731 MR S SUDRA
    4970668 1 02/01/2013 779/14904 MRS A HANN
    20105457 1 02/01/2013 779/14904 MRS A HANN
    5198375 1 02/01/2013 779/14904 MRS A HANN
    1570588 1 02/01/2013 473/36594 MRS T FITZGERALD
    1166057 1 02/01/2013 0078376051 MRS V PERCIVAL
    3607268 1 02/01/2013 0079223755 MRS M MEECHAM
    4840589 1 02/01/2013 0079223755 MRS M MEECHAM
    3361313 1 02/01/2013 135/47495 M GREEN
    3552841 1 02/01/2013 135/47495 M GREEN
    7762451 1 02/01/2013 031/13911 MRS FM MILNE
    2046150 1 02/01/2013 0077818671 MRS E HEWITT
    9904637 1 02/01/2013 0079322906 MRS L ANDREWS
    3628652 1 02/01/2013 0078423436 MRS J SIM
    4117407 1 02/01/2013 0078423436 MRS J SIM
    3621387 1 02/01/2013 0078432325 MR C CASTLEDINE
    3617366 1 02/01/2013 472/04454 MRS C SHERGOLD
    1184129 1 02/01/2013 0079310757 MR A BIGGS
    4805236 1 02/01/2013 0079310757 MR A BIGGS
    3361313 1 02/01/2013 034/45783 MRS SC LATIMER
    4774211 1 02/01/2013 473/36685 MR & J HITCH
    2233581 1 02/01/2013 473/36685 MR & J HITCH
    3455685 1 02/01/2013 0079629812 MRS S BLAKE
    5500451 1 02/01/2013 0079620613 MRS H ISTEAD
    4833987 1 02/01/2013 0079639461 MRS J DAVIES
    3451724 1 02/01/2013 0079615077 MRS R BARNETT
    4805236 1 02/01/2013 0079645454 MRS S EMMENT
    4833956 1 02/01/2013 0079610534 MRS I GIBS
    7803628 1 02/01/2013 0079362931 MR A COTTERILL
    3501856 1 02/01/2013 0078783538 MRS S CLARK
    4234869 1 02/01/2013 0078783538 MRS S CLARK
    7787072 1 02/01/2013 310/40880 MR TM GARRATT
    3515242 1 02/01/2013 310/40880 MR TM GARRATT
    3360910 1 02/01/2013 310/40880 MR TM GARRATT
    5885503 1 02/01/2013 310/40880 MR TM GARRATT
    3360972 1 02/01/2013 310/40880 MR TM GARRATT
    7787089 1 02/01/2013 164/61034 MR&M P RAMSDALE
    1128239 1 02/01/2013 0077821860 MRS L CONCANNON
    1119442 1 02/01/2013 0077821860 MRS L CONCANNON
    9938533 1 02/01/2013 0077821860 MRS L CONCANNON
    3514665 1 02/01/2013 0077881585 MRS N TUNNICLIFFE
    1300260 1 02/01/2013 0077881585 MRS N TUNNICLIFFE
    1778878 1 02/01/2013 0077943395 MRS F BALL
    1820843 1 02/01/2013 0077943395 MRS F BALL
    8056085 1 02/01/2013 0077691455 MRS M SMITH
    8072443 1 02/01/2013 0077691455 MRS M SMITH
    7978654 1 02/01/2013 0077691455 MRS M SMITH
    3246597 1 02/01/2013 473/36466 MRS B WEBSTER
    3246597 1 02/01/2013 473/36466 MRS B WEBSTER
    3262290 1 02/01/2013 473/36466 MRS B WEBSTER
    1570571 1 02/01/2013 0078119914 MRS M MCFARLANE
    1570588 1 02/01/2013 0078119914 MRS M MCFARLANE
    2985701 1 02/01/2013 0078119914 MRS M MCFARLANE
    20102913 1 02/01/2013 032/06359 MISS SA EVANS
    20102920 1 02/01/2013 032/06359 MISS SA EVANS
    1570588 1 02/01/2013 0078181953 MRS S BARRY
    1570588 1 02/01/2013 0078181953 MRS S BARRY
    2985701 1 02/01/2013 0078181953 MRS S BARRY
    2992075 1 02/01/2013 0078181953 MRS S BARRY
    3098226 1 02/01/2013 0077692884 MRS S BROADBENT
    3095911 1 02/01/2013 0077692884 MRS S BROADBENT
    3095911 1 02/01/2013 0077692884 MRS S BROADBENT
    1235388 1 02/01/2013 064/22444 MRS C ROBINSON
    1228755 1 02/01/2013 064/22444 MRS C ROBINSON
    1235500 1 02/01/2013 0077818609 MRS E HEWITT
    1235500 1 02/01/2013 0077818609 MRS E HEWITT
    9271579 1 02/01/2013 0077818609 MRS E HEWITT
    1228755 1 02/01/2013 0077818609 MRS E HEWITT
    5359721 1 02/01/2013 0077778725 MRS J READ
    5359745 1 02/01/2013 0077778725 MRS J READ
    9596917 1 02/01/2013 643/20053 MR JB NIXON
    9292949 1 02/01/2013 643/20053 MR JB NIXON
    4775683 1 02/01/2013 0077920336 MRS G BOWER
    3514665 1 02/01/2013 0077866670 MR J BELL
    3515006 1 02/01/2013 0077866670 MR J BELL
    7203374 1 02/01/2013 0077767155 MRS S WALKER
    7203374 1 02/01/2013 0077767155 MRS S WALKER
    7203350 1 02/01/2013 0077767155 MRS S WALKER
    7203350 1 02/01/2013 0077767155 MRS S WALKER
    9457171 1 02/01/2013 0077769892 MRS T MORGAN
    9692374 1 02/01/2013 0077769892 MRS T MORGAN
    1320299 1 02/01/2013 0077764179 MRS E STEWART
    7203367 1 02/01/2013 0077764179 MRS E STEWART
    3970393 1 02/01/2013 164/60872 MR&M AE NICHOLLS
    7675195 1 02/01/2013 164/60872 MR&M AE NICHOLLS
    4234913 1 02/01/2013 0078366604 J NANSON
    1570571 1 02/01/2013 0078191292 MRS S MASON
    1570571 1 02/01/2013 0078191292 MRS S MASON
    1570588 1 02/01/2013 0078191292 MRS S MASON
    2992075 1 02/01/2013 0078191292 MRS S MASON
    5956180 1 02/01/2013 031/13919 MR & KG ANGUS
    5956197 1 02/01/2013 031/13919 MR & KG ANGUS
    7787089 1 02/01/2013 0078921821 MISS H PICKARD
    4234869 1 02/01/2013 0079135236 MRS H HALE
    3622964 1 02/01/2013 0079135236 MRS H HALE
    4805243 1 02/01/2013 0079135236 MRS H HALE
    4774235 1 02/01/2013 031/13991 R GORDON
    2610726 1 02/01/2013 031/13991 R GORDON
    4234913 1 02/01/2013 031/13991 R GORDON
    9950856 1 02/01/2013 0078767331 L DOW
    3852194 1 02/01/2013 0078432310 MR C CASTLEDINE
    3785027 1 02/01/2013 473/36599 K SMITH
    4106937 1 02/01/2013 013/03629 MRS T ARMSTRONG
    4020004 1 02/01/2013 013/03629 MRS T ARMSTRONG
    4020004 1 02/01/2013 013/03629 MRS T ARMSTRONG
    7787089 1 02/01/2013 0079603126 MRS A MCROBIE
    7787072 1 02/01/2013 036/63313 MRS E LLOYD JONES
    3852187 1 02/01/2013 0078242886 MRS D ROSS
    Reply With QuoteRegister To Reply
  4. 01-04-2013, 01:07 PM #4
    Kevin UK
    Kevin UK is offline
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: HELP PLEASE ! Adding Information to a Daily Report

    Hi Sally

    Something along these lines!
    Attached Files Attached Files
    Regards Kevin


    Merged Cells (They are the work of the devil!!!)
    Reply With QuoteRegister To Reply
  5. 01-05-2013, 02:01 PM #5
    Sally Rose
    Sally Rose is offline
    Registered User
    Join Date
    01-04-2013
    Location
    Manchester
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: HELP PLEASE ! Adding Information to a Daily Report

    Hi Kevin

    Many thanks for that. How would I add more UPCs and quanties on a daily basis?

    Cheers

    Sally
    Reply With QuoteRegister To Reply
  6. 01-05-2013, 02:14 PM #6
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Adding Information to a Daily Report

    Or with an pivot table.

    See the attached file.

    Do you have questions or comments, just ask or comment.

    New info
    I was requested to remove the file, so I did.
    Last edited by oeldere; 01-05-2013 at 02:32 PM.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  7. 01-05-2013, 02:25 PM #7
    Sally Rose
    Sally Rose is offline
    Registered User
    Join Date
    01-04-2013
    Location
    Manchester
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Adding Information to a Daily Report

    Hi Oeldere

    Many thanks, yes I can do that for each individual report i get on a daily basis but how would I then keep adding this information so I have a report containing, lets say a weeks information?

    Thanks

    Sally
    Reply With QuoteRegister To Reply
  8. 01-05-2013, 02:41 PM #8
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Adding Information to a Daily Report

    And a pivot table (as promised) in #6.

    If you add all daily sheets in 1 summury sheet; you can use pivot table on that.

    Do you have questions or comments, just ask or comment.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  9. 01-05-2013, 02:18 PM #9
    Kevin UK
    Kevin UK is offline
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: Adding Information to a Daily Report

    Hi Sally

    I have updated the formula.
    Formula: copy to clipboard 
    =IF(COUNTIF($A$2:A2,A2)>1,"",SUMIF(A:A,A2,B:B))


    See the attached. Just click on cell K130 and copy down as far as required.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  10. 01-08-2013, 05:46 AM #10
    Sally Rose
    Sally Rose is offline
    Registered User
    Join Date
    01-04-2013
    Location
    Manchester
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Adding Information to a Daily Report

    Hi Kevin

    Thats fantastic, just what I needed

    Many thanks

    Sally
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1