Results 1 to 3 of 3

Reset cell based on other cell contents

Threaded View

  1. #1
    Registered User
    Join Date
    04-25-2020
    Location
    USA
    MS-Off Ver
    2010
    Posts
    4

    Reset cell based on other cell contents

    Hello and thank you for any help!!

    I am working on a PTO spreadsheet. The last piece missing is being able to reset the PTO Used column "C" to "0" if the employees anniversary date "H" is equal to "True". Column "C" cannot contain a formula since PTO taken will be manually entered there.

    Background info: Employee's earn a particular amount of PTO to use throughout the year. It does not rollover or accrue, and resets to whatever they are allotted based on years with the company on their anniversary date. All that works in the spreadsheet, but I need to 0 the amount taken on their anniversary date as well.

    Thanks again!!!
    TY
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Reset cell based on other cell contents
    By TY2 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-26-2020, 12:34 PM
  2. Replies: 5
    Last Post: 06-28-2018, 11:11 AM
  3. [SOLVED] Moving Cell Contents in a Certain Direction Based on Another Cell's Contents
    By Cloud909 in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 07-22-2016, 09:44 PM
  4. Replies: 3
    Last Post: 06-29-2015, 03:03 PM
  5. Replies: 3
    Last Post: 03-12-2014, 02:18 PM
  6. [SOLVED] Validating contents of a cell on input based on the contents of another cell
    By Saigonet in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-03-2012, 03:07 AM
  7. Split cell contents over multiple rows based on cell contents
    By naigy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-17-2011, 05:38 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