•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Best way to give each row its own edit history, selectable from a dropdown?
I maintain a tracker sheet where each row is a document (status, current revision, dates, owner, etc.). Rows get updated a lot, sometimes by hand, sometimes by a script that writes into the sheet.
What I want: for any given row, be able to click it and pull up that row's previous versions, and pick an earlier one from a dropdown (to view what it looked like before, and ideally roll a cell back). So the dropdown for row 12 shows only row 12's history, row 40 shows only row 40's, and so on.
Any one has done it? Or do I need to use sheets script for this?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#row zero
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#google sheets
#Excel alternatives
#tracker sheet
#edit history
#row
#dropdown
#revision
#cell rollback
#previous versions
#sheets script
#data tracking
#version control
#spreadsheet
#document management