+ Reply to Thread
Results 1 to 6 of 6

Help needed to fill data automatically

  1. 05-12-2022, 02:16 AM #1
    yklanka
    yklanka is offline
    Registered User
    Join Date
    01-21-2017
    Location
    SRI LANKA
    MS-Off Ver
    2013
    Posts
    19

    Red face Help needed to fill data automatically

    Dear Experts

    I am doing a excel report to enter data in to a list for a supervisor . It contains data of vessel operation.in the first workbook called "Log" we need to enter data ie, crane number, hatch number, truck ID, Truck in time, Truck Out time, number of grabs per truck and total tonnage. Truck operation has 2 methods truck to yard(Y) and truck to direct delivery(DD)

    In order to make a summary in the summary work book, we need to fill data in to the summery as follows.
    Truck in time need to be in the hourly range, and within that hour
    1. how many ' Y ' trucks from crane 1 ,how many grabs and total MT (Tonnage)
    2. how many 'DD' trucks from crane 1,how many grabs and total MT (Tonnage)

    (maximum cranes is 5 at the moment. Hatch wise figures is not designed yet)

    Many thanks in advance for the kind help!!
    best regards/yklanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-12-2022, 02:20 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,432

    Re: Help needed to fill data automatically

    Administrative Note:

    Members will tailor the solutions they offer to the version (NOT release number) of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 05-12-2022, 02:45 AM #3
    yklanka
    yklanka is offline
    Registered User
    Join Date
    01-21-2017
    Location
    SRI LANKA
    MS-Off Ver
    2013
    Posts
    19

    Re: Help needed to fill data automatically

    hi, my excel is Microsoft office standard 2013.
    Reply With QuoteRegister To Reply
  4. 05-12-2022, 05:58 AM #4
    JohnTopley
    JohnTopley is offline
    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
    28,361

    Re: Help needed to fill data automatically

    in V9

    =COUNTIFS(Log!$I$9:$I$20,">=" &$B9,Log!$I$9:$I$20,"<" &$B9+(1/24),Log!$F$9:$F$20,E$7,Log!$B$9:$B$20,V$7)

    in W9

    =IFERROR(INDEX(Log!L1:L12,AGGREGATE(15,6,ROW($A$1:$A$20)/(Log!$I$9:$I$20>=$B9)/(Log!$I$9:$I$20<$B9+(1/24))/(Log!$B$9:$B$20=V$7),1)),"")

    in X9

    =SUMIFS(Log!$N$9:$N$20,Log!$I$9:$I$20,">=" &$B9,Log!$I$9:$I$20,"<" &$B9 +(1/24),Log!$B$9:$B$20,V$7)

    Changed column I in LOG to proper date/time and formatted as "dd/mm/yyyy hh;mm"

    changed dates in Log to be February (to match Summary dates)

    Hopefully, you should be able to modify the above for the other ranges.
    Attached Files Attached Files
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  5. 05-12-2022, 07:48 AM #5
    yklanka
    yklanka is offline
    Registered User
    Join Date
    01-21-2017
    Location
    SRI LANKA
    MS-Off Ver
    2013
    Posts
    19

    Re: Help needed to fill data automatically

    Hi John, really appreciate and its a big help. Many thanks . I can manage from now on with other fields. Greetings!!
    Reply With QuoteRegister To Reply
  6. 05-12-2022, 07:53 AM #6
    JohnTopley
    JohnTopley is offline
    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
    28,361

    Re: Help needed to fill data automatically

    Thank you for the feedback and the rep.
    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)

Similar Threads

  1. Code Adjustment Needed - Fill A Sheet With Data From 3 Different Sheets - VBA
    By Kelly mort in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-28-2020, 06:25 AM
  2. Automatically fill data into second sheet?
    By CPS624 in forum Excel General
    Replies: 6
    Last Post: 03-20-2017, 11:58 AM
  3. Fill in data automatically only if previous cells data match with data from another table
    By superanova in forum Excel General
    Replies: 2
    Last Post: 04-19-2014, 10:06 PM
  4. code example needed to Insert row if conditions are met then fill some data
    By muddbog in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-12-2014, 12:38 PM
  5. Formula to Automatically Fill Blank With Next fill cell's data?
    By VMoney in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-22-2013, 05:11 PM
  6. Excel: webbrowser control needed to automatically fill in form
    By mantona in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-17-2009, 10:33 AM
  7. How can I fill data in a list automatically?
    By KFuda in forum Excel General
    Replies: 1
    Last Post: 11-04-2005, 02:40 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1