Results 1 to 3 of 3

changing a cell value when the date changes to a new month

Threaded View

  1. #1
    Registered User
    Join Date
    06-06-2018
    Location
    texas
    MS-Off Ver
    2010
    Posts
    2

    changing a cell value when the date changes to a new month

    hi I've been stumped on this one for a while I am trying to set up an account reading system for water meters and it has a beginning amount (A1) and
    end amount (B1). what I would like for it to do is when the new month comes around and I change the date on the spread sheet A1 will take the value of B1, but every time I try it with IF or Switch functions once I start to put a new amount in B1 it also changes A1 and I don't want it to do that.

    Is there any way to accomplish this.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Date isssue keeps changing the month and day
    By Lextar in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-22-2013, 10:50 AM
  2. changing colour of cell if todays date equals the first day of the month
    By ConfusedaboutVBA in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-24-2013, 08:03 PM
  3. date changing into only month and year
    By excel5111987 in forum Excel General
    Replies: 1
    Last Post: 05-28-2011, 11:18 AM
  4. Changing the date in a cell every month
    By bopsgtir in forum Excel General
    Replies: 3
    Last Post: 12-21-2010, 01:51 PM
  5. loop through selectioin changing day in date to last day in the month
    By christo in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-01-2008, 02:22 AM
  6. Changing a date back one month
    By John in forum Excel General
    Replies: 7
    Last Post: 02-07-2006, 08:15 AM
  7. [SOLVED] a Month to Date and Year TD page in one sheet changing each day?
    By Mark A. Fresh in forum Excel General
    Replies: 1
    Last Post: 01-05-2006, 07:10 AM
  8. [SOLVED] Changing today's date to the first of the month
    By Scott in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-22-2005, 10:25 AM

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