•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Date sheet in workbook last updated
I've inherited ownership of an Excel workbook with multiple sheets in it. I've been told I need to verify the data in each sheet where its not ben updated in more than 6 months. There is, of course (currently), no "last updated field" either in each sheet or in the index sheet. I'd prefer not to have to update every sheet just to be safe, so is there a way to find out the date a sheet was last amended?
Happy to do it via VBA as a one off macro to update the index sheet and then have an Excel function for future updates.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#generative AI for data analysis
#rows.com
#natural language processing for spreadsheets
#big data management in spreadsheets
#conversational data analysis
#google sheets
#real-time data collaboration
#financial modeling with spreadsheets
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#Excel
#workbook
#sheets