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