+ Reply to Thread
Results 1 to 1 of 1

Copy Daily Changeable Value to other Sheet

  1. #1
    Registered User
    Join Date
    06-20-2014
    Location
    Hannover, Germany
    MS-Off Ver
    Office 2010
    Posts
    9

    Copy Daily Changeable Value to other Sheet

    Dear experts,
    could you please assist me.

    My problem is: I got 2 sheets 1)Roster and 2)DailyReport.
    DailyReport, everyday updated with a names of those who are on the shift (names and shifts are from Roster based on Date value), but sometimes shifts starting earlier or ending later, that's why there are possibility to my employees manually to change shift length (From - To).
    I would like to copy manual adjustments (if there were any) from DailyReport to Roster 3rd line. The problem is with my formula, formula is based on date value IF(date today from Roster=date in daily report)..
    =IF(E4='Daily Report'!O1;VLOOKUP(Roster!A8;'Daily Report'!A43:D65;4;FALSE);Roster!E7)
    Everything working until date is changed, then IF formula ar looking only values for today, and yesterday is already 0.
    Is it possible somehow to avoid that, and to save value for each day?

    Please find printScreens attached.

    Thank you in advance, I will really appreciate any help
    Attached Images Attached Images

+ 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. Protection: Making Cell Values Copy-able but not Changeable?
    By lowprofile in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-14-2014, 05:10 PM
  2. Daily Allowance Calculation From Previous Daily Spending Against A Daily Budget
    By WillYoung351 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-03-2014, 05:00 PM
  3. How to transfer data from a daily input sheet to a separate monthly total sheet
    By Jcooper71 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2014, 02:37 PM
  4. VBA CODE to Copy Paster data from one sheet to other sheet on a daily basis
    By aravindkm in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-26-2013, 12:06 PM
  5. Copy Daily data to Monthly data sheet
    By jbeardslee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-21-2012, 08:39 AM
  6. Replies: 13
    Last Post: 05-18-2012, 10:53 AM
  7. Replies: 0
    Last Post: 01-06-2009, 05:42 PM

Tags for this Thread

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