+ Reply to Thread
Results 1 to 9 of 9

Generate report based on master file dates and delivery notes

  1. #1
    Registered User
    Join Date
    04-04-2013
    Location
    India
    MS-Off Ver
    Excel 2019
    Posts
    95

    Generate report based on master file dates and delivery notes

    Hello, I need help to generate a report (Sheet "Report-A" & "Report-B" ) based on the dates (column F) and delivery notes (column E) from the master file. Sample workbook attached.

    Thank you.

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,215

    Re: Generate report based on master file dates and delivery notes

    File not attach. Plz attach file.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,602

    Re: Generate report based on master file dates and delivery notes

    There is no workbook attached.

    To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

    Note that the Paperclip icon does not work.

    Hope this helps.

    Pete

  4. #4
    Registered User
    Join Date
    04-04-2013
    Location
    India
    MS-Off Ver
    Excel 2019
    Posts
    95

    Re: Generate report based on master file dates and delivery notes

    Sorry.. I submitted a new thread.
    Attached Files Attached Files
    Last edited by sharathnarayanan; 01-27-2017 at 05:09 AM.

  5. #5
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,602

    Re: Generate report based on master file dates and delivery notes

    You didn't need to start a new thread.

    Pete

  6. #6
    Registered User
    Join Date
    04-04-2013
    Location
    India
    MS-Off Ver
    Excel 2019
    Posts
    95

    Re: Generate report based on master file dates and delivery notes

    sample workbook attached.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    04-04-2013
    Location
    India
    MS-Off Ver
    Excel 2019
    Posts
    95

    Re: Generate report based on master file dates and delivery notes

    Quote Originally Posted by Pete_UK View Post
    You didn't need to start a new thread.

    Pete
    workbook attached
    Attached Files Attached Files

  8. #8
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    27,999

    Re: Generate report based on master file dates and delivery notes

    Try

    in E7 of "Report_A"

    =SUMIFS(Master!$P:$P,Master!$F:$F,$A7,Master!$E:$E,$B7)

    format as 0;;;@

    in F7

    =SUMIFS(Master!$Q:$Q,Master!$F:$F,$A7,Master!$E:$E,$B7)

    format as 0.00;;;@


    in Report_B

    in D19

    =delivery_Notes(DELIVERY_NOTE)

    Concatenates Delivery notes (5 per "line")

    DELIVERY_NOTE is named range

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by JohnTopley; 01-28-2017 at 01:10 PM.

  9. #9
    Registered User
    Join Date
    04-04-2013
    Location
    India
    MS-Off Ver
    Excel 2019
    Posts
    95

    Re: Generate report based on master file dates and delivery notes

    Thanks for your help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Generate subsheet or workbook based on master
    By ChrisLN in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 09-23-2016, 08:59 AM
  2. [SOLVED] Need VBA Help on MS-Access to generate report & save to xlsb file to tageted file
    By breadwinner in forum Access Programming / VBA / Macros
    Replies: 6
    Last Post: 05-23-2014, 07:52 AM
  3. Help! Macro to Generate email in Lotus Notes and automatically attach a file
    By elpollo87 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-27-2012, 10:19 AM
  4. [SOLVED] Generate report based on list of data Validation.
    By hecgroups in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-24-2012, 12:26 PM
  5. how to generate report based on adding costs of particular category
    By hoser in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-20-2007, 06:58 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1