+ Reply to Thread
Results 1 to 3 of 3

cell equals last entry on a previous worksheet

Hybrid View

  1. #1
    Registered User
    Join Date
    05-13-2022
    Location
    Michigan USA
    MS-Off Ver
    Windows365
    Posts
    2

    cell equals last entry on a previous worksheet

    I have a set of worksheets to track spending, 1 sheet for each week. I would like the starting balance of the new weeks' worksheet to automatically equal the last entry in the previous worksheet. i.e. the starting balance on the week 2 worksheet (cell L3) would automatically have the last dollar amount entered on the week 1 worksheet (the last entry in column L).

    I have tried several things and have not really found a reliable way to do this.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,289

    Re: cell equals last entry on a previous worksheet

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    05-13-2022
    Location
    Michigan USA
    MS-Off Ver
    Windows365
    Posts
    2

    Re: cell equals last entry on a previous worksheet

    trying but is not as simple as it is written. Don't know if it is attached - I tried that with the original post. if it isn't I guess I am on my own
    Attached Files Attached Files

+ 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] If rows has a new entry performs a highlight at the previous entry
    By emina002 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-05-2018, 10:53 PM
  2. [SOLVED] Restrict Data Entry if previous cell doesn't fall between a particular range
    By dezspert22 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-12-2016, 06:27 PM
  3. Copy and Pasting to another worksheet if cell value equals name of worksheet
    By Andrewstupendo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-11-2016, 03:53 PM
  4. Copy a row to a worksheet when cell value equals the worksheet name
    By jakebrad38 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-26-2014, 12:22 PM
  5. if cell equals value then return previous cell address
    By gammaman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-28-2014, 11:03 AM
  6. Replies: 1
    Last Post: 01-23-2011, 08:00 AM
  7. Replies: 2
    Last Post: 09-18-2008, 05:47 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