I have a workbook where users fill in data into multiple tables. My primary table looks like this:
As users enter data into this sheet, I would like the name columns to autopopulate in other tables, like this (users will then fill in the blank columns of this table):
I then use Power Query to manipulate the data from the tables to create Pivot Tables and Charts. After searching, I have not figured out a way to do this that still allows users to sort and filter tables. Looking for any suggestions.
Thank you.
Table Populate test.xlsx | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Last Name | First Name | Base Yearly Salary | Bonus | ||
2 | McGoo | Jenny | $ 56,700 | 5% | ||
3 | Winter | Laurie | $ 78,000 | 4% | ||
4 | Marsh | Elgin | $ 65,000 | 5% | ||
Data |
As users enter data into this sheet, I would like the name columns to autopopulate in other tables, like this (users will then fill in the blank columns of this table):
Table Populate test.xlsx | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Last Name | First Name | OT January | OT February | OT March | ||
2 | McGoo | Jenny | |||||
3 | Winter | Laurie | |||||
4 | Marsh | Elgin | |||||
OT |
I then use Power Query to manipulate the data from the tables to create Pivot Tables and Charts. After searching, I have not figured out a way to do this that still allows users to sort and filter tables. Looking for any suggestions.
Thank you.