I have an Excel sheet I want to use, where someone can select a Project (Column A = Project1, Project2 ..) a date (Row 1), and a rate of pay (Row 2 = x1, x1.5 and x2)
then enter an amount of hours which will populate the correct cell. There will end of being 000's of projects and span an entire year, hence the reason for an input box. I have tried to use the code enclosed however end up with a few problems.
- The lists end up with gaps in between them and
- I can not make the code take the input form data and place it in the correct cell.
I have tried searching google and YouTube but having no luck and my "coding" ability is basic at best
Thank you for any help