•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
PM Dashboard Assistance Please
Hi everyone, so I need some help just figuring out how I would do this. I was tasked with creating an Excel based Project Management dashboard that allows the user to select a project based on a project name and a specific date. This would show notes associated with that date.
That part was easy, I used an INDEX MATCH function, and it works perfect. My problem is that I need to add a button that looks up the Project Name and Date and then overwrites the notes associated for both. I'll need a Macro for this but how would I write this? How would I allow users to add new notes for a future date?
Any suggestions would be helpful. Thank you everyone.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#cloud-based spreadsheet applications
#financial modeling with spreadsheets
#Excel alternatives
#rows.com
#big data management in spreadsheets
#enterprise data management
#Project Management
#Excel
#dashboard
#INDEX MATCH
#Macro
#user selection
#project name
#specific date
#notes
#lookup