+ Reply to Thread
Results 1 to 2 of 2

Make date change affect another cell numerically

  1. #1
    Registered User
    Join Date
    12-02-2020
    Location
    Florida
    MS-Off Ver
    Microsoft 365
    Posts
    1

    Make date change affect another cell numerically

    Attached, I hope, is a small receipt for which I and want to know how to have a date change in one cell (F2) change a dollar amount in another cell (E9). I want the amount in cell E9 to be reduced by whatever amount is in a third cell (F4).
    What I hope to get is that whenever a date change is entered in cell F2, E9 (the balance) will be reduced by whatever payment amount is in F4.
    This is outside of my familiarity with Excel. Yes, I can do simple math between cells but not using a date. If something more detailed would work, I would need a better understanding of the formula to do it myself.
    I would appreciate any help...
    Thank you,
    Sharon2287
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Make date change affect another cell numerically

    Welcome.

    I think that you need a macro to run whenever you change F2.

    The macro is quite simple.


    Right Click On Your Sheet Name At the Bottom Of Excel and Select View Code
    Paste this code in the module that opens and close it.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

+ 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. [SOLVED] How to make one cell affect another?
    By Benhoughton in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-19-2023, 09:56 AM
  2. [SOLVED] Code to make a cell number change if a predetermined date has passed
    By richard11153 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-18-2019, 10:11 AM
  3. How to make a cell adaptively change color based on its date?
    By Thlian in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-11-2018, 05:11 PM
  4. Unable to make a cell change colour depending on another cells date.
    By rjhardman in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-09-2015, 12:13 PM
  5. Make a code affect given cloumns
    By Generalist in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-10-2015, 09:43 AM
  6. How to make one cell affect another by adding +1 to it.
    By evicktd in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-21-2011, 01:08 PM
  7. How do i make a change in one worksheet affect the others
    By elleblaze in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-21-2006, 06:10 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