CantCode
02-10-2020, 03:03 AM
Hi All,
First post so hoping for some help. I have tried various search engines and video teaching platforms and am completely stuck.
Within Excel 2016 I am trying to create a UserForm where the user selects a Project from a drop down and a date, then enters either 1,1.5 or 2. Once they click "Ok" the value would be entered in the correct cell.
I imagine this will be along the lines of an index and match formula to find the data, but I have no idea how get the 1,1.5 or 2 into the relevant cell. I have set up a user form which is linked to the relevant lists.
Please let me know if this is not clear or you need me to expand,
Thank you
10/02/2020
17/20/20
Project 1
Project 2
Project 3
...
First post so hoping for some help. I have tried various search engines and video teaching platforms and am completely stuck.
Within Excel 2016 I am trying to create a UserForm where the user selects a Project from a drop down and a date, then enters either 1,1.5 or 2. Once they click "Ok" the value would be entered in the correct cell.
I imagine this will be along the lines of an index and match formula to find the data, but I have no idea how get the 1,1.5 or 2 into the relevant cell. I have set up a user form which is linked to the relevant lists.
Please let me know if this is not clear or you need me to expand,
Thank you
10/02/2020
17/20/20
Project 1
Project 2
Project 3
...