Results 1 to 2 of 2

Thread: Retrieve Data from one worksheet and place it in another organized by date.

  1. #1
    Seeker hlaur's Avatar
    Join Date
    Feb 2019
    Posts
    7
    Articles
    0
    Excel Version
    2016

    Retrieve Data from one worksheet and place it in another organized by date.



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

    Hello,
    I am very new to VBA, so thanks in advance for your patience.

    I have attached a file where all Work Order info is inputted into a log in Sheet1. Sheet2 is an employee timesheet.

    I want to autopopulate the employee timesheet with the information from every new work order that is inputted into the log.
    I understand how to do this through the use of IF, VLOOKUP, and WEEKDAY functions in the cells themselves, but this leaves a lot of blank rows on the timesheet, therefore I would like to avoid this by using VBA.

    Essentially, this is what I want the program to do:

    If Date Completed in Sheet1 is a Monday, then
    Extract Work Order #, Description, Time Started and Time Completed from that same row in Sheet1
    And place them in the first blank row under the Monday category in Sheet2

    Any help or hints at all would be greatly appreciated.

    Thanks!
    excelhelp.xlsx
    Last edited by hlaur; 2019-10-09 at 03:02 PM.

  2. #2
    Seeker hlaur's Avatar
    Join Date
    Feb 2019
    Posts
    7
    Articles
    0
    Excel Version
    2016
    Quite literally any help at all folks. Please. If I'm in the wrong thread just kindly direct me to the right one

Tags for this Thread

Posting Permissions

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