+ Reply to Thread
Results 1 to 4 of 4

Cells that Populates by date & doesn't delete previous days

  1. #1
    Registered User
    Join Date
    07-28-2014
    Location
    NJ
    MS-Off Ver
    2010
    Posts
    39

    Cells that Populates by date & doesn't delete previous days

    Excel Masters!!

    So I have an excel workbook that I am developing to track how much our labor cost is for how much material is shipped each day. I am pulling in data for employee hours worked each day (into "Morning Report Simplified" sheet), then manually pulling the information from range P4:33 on the "Morning Report Simplified" sheet and inputting that information into the "Employee Hours" sheet for that respective day's row.

    The issue:

    I am sure there is a way to automate this process. At first I was thinking a simple reference, however I am updating the information on the "Morning Report Simplified" sheet everyday so the information on the "Employee Hours" sheet would keep overwriting itself. The only way I can think of to make this work is to use some sort of time stamp for when I update the raw data in the "Morning Report Simplified" and updating the corresponding rows information for that day in the "Employee Hours" sheet. So to say the cells are told, "ok you have yesterdays information, tomorrow I am going to pull in the new data and not delete any other previous days information". Sorry this is my weird way of thinking for what I want the cells to be doing lol.

    Anyway any help or direction in this matter will be greatly appreciated.

    - DasBurgers

    CostperKilo_3.xlsx

  2. #2
    Registered User
    Join Date
    07-28-2014
    Location
    NJ
    MS-Off Ver
    2010
    Posts
    39

    Re: Cells that Populates by date & doesn't delete previous days

    ^^^bump^^^

  3. #3
    Registered User
    Join Date
    07-28-2014
    Location
    NJ
    MS-Off Ver
    2010
    Posts
    39

    Re: Cells that Populates by date & doesn't delete previous days

    buumppp^^^

  4. #4
    Registered User
    Join Date
    07-28-2014
    Location
    NJ
    MS-Off Ver
    2010
    Posts
    39

    Re: Cells that Populates by date & doesn't delete previous days

    Please 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. Asking for previous date plus two days
    By KJBrown in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-21-2014, 10:02 AM
  2. Replies: 3
    Last Post: 02-09-2006, 10:30 AM
  3. date functions for previous 60/90/180 days
    By BBranch in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  4. date functions for previous 60/90/180 days
    By BBranch in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 AM
  5. [SOLVED] date functions for previous 60/90/180 days
    By BBranch in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-02-2005, 01:05 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