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?
Bookmarks