1 min readfrom 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.

submitted by /u/Deceptijawn
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

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