Dynamically populate name column from one table into another

[theyaaz]

I have a workbook where users fill in data into multiple tables. My primary table looks like this:

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.

 

[OaklandJim]

I can't tell but this seems to require some VBA. Have a look at (Google) worksheet change event. You can use that to grab the new name and put it into other tables.

How many tables are there? Can you post pieces of the other tables? Have you named the tables? Click within a table. Use the Table Design menu item that appears.

If you can post the other tables that would help someone willing to assist. I'd be willing to give it a try.