Hello,
Hoping someone can help. I built a basic, formula driven tool (attached) that is used by colleagues to view the average salary for gender, discipline, location etc. It requires a manual refresh each week, with new data added to the DATA tab - which updates two PIVOT tables, which I then paste into the FIELDS tab. Recently I have had a few requests to make it a bit more dynamic, giving people the option to select multiple disciplines and/or offices etc instead of one from a drop down.
I am sure a VBA script would make this a much more dynamic tool to use and perhaps limit the refreshing I have to do each week. Any thoughts would be greatly appreciated!
DATA - raw data (anonymised in this case)
PIVOT - GNDR AVG - Pivot table showing the average FTE salary for grade/office/discipline/gender
PIVOT-LOWHIGH - Minimum and Maximum salary for grade/office/discipline
FIELDS - data validation lists for the TOOL tab and the pasted pivot tables from the PIVOT-GNDR AVG and PIVOT-LOWHIGH tabs
TOOL - the user interface (the only tab showing for my colleagues).
Bookmarks