Hi all,
I'm working on a new man power vs workload calculator in excel for work.
I've built the overall design and various userforms, cell formula's etc but I'm a little stuck on the complex VBA i need to implement for the document to actually work as design.
As you can see from the image above, I have a Project Details Form. This form has three comboboxes that retrieve data from the DataTables worksheet. All the data on the DataTables sheet is persistent baring the Project names, as they will always change. All other data, TesterID's, Test Types, Workload Slots etc will always be the same.
Ok, so the problem I have is I need to know how to get the userform to find and match the slot number found on the "Calculator" sheet with the slot number the user has selected on the userform.
From there, I would like the userform to populate the corresponding cells to the right of the selected slot with the other data from the userform; Project name and Test Stage.
For example; the user opens the userform. Selects "Slot_01" from the workload slot #, and then selects "Dumby Project 1" from the "Project" drop down. And finally "1st Full QA" from the "Test Stage" drop down. If the user then hits "Submit", the above data should be populated in Row 11, in cells B11, D11 and F11.
If anyone can help me with this, I'd be most grateful.
Please ignore the "Durations" section of the userform. I can probably work that out once I have the other part sorted.
Many Thanks,
Adam
I'm working on a new man power vs workload calculator in excel for work.
I've built the overall design and various userforms, cell formula's etc but I'm a little stuck on the complex VBA i need to implement for the document to actually work as design.
As you can see from the image above, I have a Project Details Form. This form has three comboboxes that retrieve data from the DataTables worksheet. All the data on the DataTables sheet is persistent baring the Project names, as they will always change. All other data, TesterID's, Test Types, Workload Slots etc will always be the same.
Ok, so the problem I have is I need to know how to get the userform to find and match the slot number found on the "Calculator" sheet with the slot number the user has selected on the userform.
From there, I would like the userform to populate the corresponding cells to the right of the selected slot with the other data from the userform; Project name and Test Stage.
For example; the user opens the userform. Selects "Slot_01" from the workload slot #, and then selects "Dumby Project 1" from the "Project" drop down. And finally "1st Full QA" from the "Test Stage" drop down. If the user then hits "Submit", the above data should be populated in Row 11, in cells B11, D11 and F11.
If anyone can help me with this, I'd be most grateful.
Please ignore the "Durations" section of the userform. I can probably work that out once I have the other part sorted.
Many Thanks,
Adam