+ Reply to Thread
Results 1 to 2 of 2

Use closed values from last month as opening values for new month

  1. #1
    Registered User
    Join Date
    07-03-2014
    Location
    Johannesburg
    MS-Off Ver
    Office 2010
    Posts
    17

    Use closed values from last month as opening values for new month

    Hi,

    I've hit a brick wall with the following...

    I would like to know if there is a way of using the last readings taken (water readings for a complex) and use them as opening readings for the new month? Other than copy and paste... There are also electricity readings but I'll add to this later. I just need to figure out the first step. I have attached an example....

    Your help would be greatly appreciated
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    06-23-2014
    Location
    Dubbo, Australia
    MS-Off Ver
    EXCEL 2019
    Posts
    180

    Re: Use closed values from last month as opening values for new month

    Hi Zorro,

    VLookup does that job, and can be modified easily to accommodate the number of units

    see attached
    Pete
    Attached Files Attached Files
    Pete
    Struggling Solutions Architect

  3. #3
    Registered User
    Join Date
    07-03-2014
    Location
    Johannesburg
    MS-Off Ver
    Office 2010
    Posts
    17

    Re: Use closed values from last month as opening values for new month

    Hi Pete,
    Thanks very much for your quick response - much appreciated. Sometimes keeping it simple always works best

+ 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] Determine work days in current month or next month based on day of the month
    By sbrnard in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-29-2014, 05:14 PM
  2. [SOLVED] Auto instert Month names for This month, Last month and Next month
    By hemal89 in forum Word Programming / VBA / Macros
    Replies: 4
    Last Post: 12-10-2013, 12:01 PM
  3. [SOLVED] Summing cumulative daily values for each month then resetting next month
    By JaredZ in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-21-2012, 06:04 AM
  4. [SOLVED] Formula to Relist Ranges by Month Opening instead of Calendar Month
    By investmentbanker in forum Excel General
    Replies: 3
    Last Post: 05-18-2012, 01:33 PM
  5. assigning date entries to week values and month values to sum column C-N values C-
    By the accountant in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-20-2010, 09:52 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