How to use a table column as the primary column of another table

[reaktorblue]

I have a worksheet labelled "Roster" and in this worksheet is a table with the columns "Learner", "Email", "Supervisor"

I have a second worksheet in the same spreadsheet labelled "Attendance" and in this worksheet is a table with the columns "Learner", "5/1", 5/2". I'd like to have this table's "Learner" column auto populate from the entries in the "Roster" table.

Since it's a table, I can't use =tblRoster[Learner] without getting spill errors. Is there a way that I can accomplish this?

 

[alansidman]

Post a sample worksheet of your data and a mock up solution. Do not post a picture, but use the add in function XL2BB.

 

[reaktorblue]

Here are the two tabs.

This tab is "Roster" and is a table that is made at the start.

Test.xlsm
	A	B	C
1	Learner	Email	Supervisor
2	Amy Doe	amydoe@email.com	Garfield
3	Barry Doe	barrydoe@email.com	Garfield
4	Cathy Doe	cathydoe@email.com	Heathcliff
5	Jane Doe	janedoe@email.com	Garfield
6	John Doe	johndoe@email.com	Garfield
Roster

This tab is "Attendance" and I'd like to have the "Learner" column update dynamically, depending on the entries in the "Roster" tab.

Test.xlsm
	A	B	C	D
1	Learner	12-May	13-May	14-May
2	Amy Doe	Present	Absent	Absent
3	Barry Doe	Present	Present	Present
4	Cathy Doe	Present	Present	Present
5	Jane Doe	Present	Present	Present
6	John Doe	Present	Present	Absent
Attendance

For example, if I were to add Fred Flintstone to the "Roster" I would then get an entry in "Attendance" to keep track of that person's attendance.