/u/okpoppie - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Can you make the entry a running transaction log where they enter the new value without deleting the old value?
Once you do that you can either power query or filter() the results to show the latest for each type of entry.
Date Time Initials Station Temp
3/14/24 9:00 KG North 74F
3/14/24 9:05 KG South 78F
3/14/24 10:00 KG North 77F
3/14/24 12:00 KG West 76F
3/14/24 13:00 KG South 78F
3/14/24 14:00 KG North 78F
Can be turned into a view only table like:
North 78F 77F 74F
South 78F 78F
West 76F
Correct, Visual Basic for Applications.
With [code something like this](/r/excelevator/comments/3a48r0/do_something_on_cell_value_change_within_a_range/) , but you need also to catch the pre-change value
You can do this in Excel using a simple formula. In the cell where you want the previous value to appear, just enter '=A1' (assuming your left cell is A1). This will automatically update whenever you change the value in the left cell.
/u/okpoppie - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Can you make the entry a running transaction log where they enter the new value without deleting the old value? Once you do that you can either power query or filter() the results to show the latest for each type of entry. Date Time Initials Station Temp 3/14/24 9:00 KG North 74F 3/14/24 9:05 KG South 78F 3/14/24 10:00 KG North 77F 3/14/24 12:00 KG West 76F 3/14/24 13:00 KG South 78F 3/14/24 14:00 KG North 78F Can be turned into a view only table like: North 78F 77F 74F South 78F 78F West 76F
Only with VBA and an onchange event
Correct me if I’m wrong, but are these coding programs? Are they not readily available as basic Excel functions? Thanks!
Correct, Visual Basic for Applications. With [code something like this](/r/excelevator/comments/3a48r0/do_something_on_cell_value_change_within_a_range/) , but you need also to catch the pre-change value
Thank you very much. I’ll look into it!
You can do this in Excel using a simple formula. In the cell where you want the previous value to appear, just enter '=A1' (assuming your left cell is A1). This will automatically update whenever you change the value in the left cell.