Andross9
asked on
How to create command button to populate multiple selections in another table
I have a section of a worksheet which is to function as a "user interface", allowing the user to make selections of details about an employee.
the user would enter then enter dates stipulating the period of time that this combination applied for.
E.g. If an employee changed from a casual to a full time or went from a level 2 to level 3 employment classification we need to keep a running sheet on these changes.
If looking at the example attatched, basically need a Macro that is capable of copying data from the cells and validation lists above the red line into the cells below the line (marked in yellow).
Once an user has made one selection and copied it down to the yellow cells, they need to have the ability to add further combinations and have them added to the table below. I.E the first combinations copied into row 19, then row 20 etc.
And help would be greatly appreciated UIexample.xlsx UIexample.xlsx
the user would enter then enter dates stipulating the period of time that this combination applied for.
E.g. If an employee changed from a casual to a full time or went from a level 2 to level 3 employment classification we need to keep a running sheet on these changes.
If looking at the example attatched, basically need a Macro that is capable of copying data from the cells and validation lists above the red line into the cells below the line (marked in yellow).
Once an user has made one selection and copied it down to the yellow cells, they need to have the ability to add further combinations and have them added to the table below. I.E the first combinations copied into row 19, then row 20 etc.
And help would be greatly appreciated UIexample.xlsx UIexample.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent solution. Exactly the result I was looking for.
However also need it to be able to capture the values entered in Row Q and the dates entered in V4 and X4.
Tried to vary the Macro to achieve this but was not successful.
However also need it to be able to capture the values entered in Row Q and the dates entered in V4 and X4.
Tried to vary the Macro to achieve this but was not successful.
ASKER
Got it working for other areas too, excellent solution. Quite easy to follow with a bit of playing. Thanks!
jppinto