+ Reply to Thread
Results 1 to 3 of 3

Appending text entered in one cell to the end of an existing cell in a different sheet

  1. #1
    Registered User
    Join Date
    11-24-2016
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    3

    Appending text entered in one cell to the end of an existing cell in a different sheet

    Hi. Ok, I am going to try and explain this properly.

    I was looking to build some functionality into an excel tracker file. I currently have one "Tracker" sheet where a "Status" column exists, used to manually enter updates for the item in that row. Currently the update is just text being typed in so that it is appended to the start of the existing text in that cell. I want to modify it by adding a sheet called "History" which would basically have all the same data as "Tracker" but I want the Status cell in it to capture all entries ever entered in the Status cell on the Tracker sheet. The Status cell in "Tracker" sheet would only retain/display the last update made and any previous entries in that cell will get "pushed" to the corresponding Status cell in the "History" sheet. So basically, the Status cell on the Tracker sheet is just an "input" box which displays the last update entry whereas the Status cell on the History sheet contains all entries ever made, all in one box.

    Would I need to do some kind of programming for this?

  2. #2
    Forum Contributor
    Join Date
    10-30-2014
    Location
    England
    MS-Off Ver
    2007 / 365
    Posts
    279

    Re: Appending text entered in one cell to the end of an existing cell in a different sheet

    Quote Originally Posted by sali1979 View Post
    Would I need to do some kind of programming for this?
    Yes - if any trace of the previous status is removed from the sheet, there will be no way of retaining it with a formula.

    It's not a difficult macro to create - it's simply adding or appending a value to a cell.

    As one idea, you could run a macro at the end of the day that will look down the status column, and if the value is different to the one in the history sheet, it will copy it over and append it to the history status cell, or you could even just add it to the next column along each time. It really depends how you want to work your file.

    If you can post a sample of your file and indicate your desired result, I'm sure a few people will come up with a good solution for you.
    Last edited by EchoPassenger; 11-24-2016 at 05:03 PM.

  3. #3
    Registered User
    Join Date
    11-24-2016
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    3

    Re: Appending text entered in one cell to the end of an existing cell in a different sheet

    Thanks for your suggestion. I am going to try the macro first.

+ 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. Replies: 1
    Last Post: 11-24-2016, 05:31 PM
  2. storing text entered in one cell to another sheet.
    By geofferysebastian in forum Excel General
    Replies: 13
    Last Post: 07-23-2010, 08:19 AM
  3. Appending data from a second sheet into existing sheets
    By Ace of Clubs in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-09-2009, 10:54 PM
  4. [SOLVED] Appending to a cell content loses existing data formatting
    By DejaUser in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-31-2006, 04:10 PM
  5. [SOLVED] appending text to existing values
    By anny in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-28-2006, 02:25 PM
  6. [SOLVED] Appending to a Cell doesn't keep format of existing content
    By DejaUser in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-25-2006, 05:45 PM
  7. Appending Text to a Cell Value
    By Pappey in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-26-2005, 03:06 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