As management at work seem to be completely useless at filling out forms I'm trying to update one of the HR forms to make it as easy as possible for them.
We have a bunch of spreadsheets with pay rates for roles. Each role has 9 different pay rates (weekdays, weekends, bank holidays, different rates at different times of day). What I'd like to do is create a dropdown that, when clicked, populates all the pay rates for that role from a hidden sheet in the workbook into a column so even the most IT challenged of our managers can't get it wrong. My Excel-fu has never been particularly strong as I've never had to use it in anger. I can usually find the answer I'm looking for online or from a colleague but neither seem to be working for this particular challenge. I've been looking at data validation lists so far but I'm not sure that's going to work for this.
We have a bunch of spreadsheets with pay rates for roles. Each role has 9 different pay rates (weekdays, weekends, bank holidays, different rates at different times of day). What I'd like to do is create a dropdown that, when clicked, populates all the pay rates for that role from a hidden sheet in the workbook into a column so even the most IT challenged of our managers can't get it wrong. My Excel-fu has never been particularly strong as I've never had to use it in anger. I can usually find the answer I'm looking for online or from a colleague but neither seem to be working for this particular challenge. I've been looking at data validation lists so far but I'm not sure that's going to work for this.
Last edited:
