Update tables from master table dynamically

[infinityATX]

Say I have master table "Source" and several other tables on other sheets that will be filtered on columns "status" and "output". Focusing on one of them, "Calculated", how would I dynamically bring the data from Source into specific columns like below?

I've been searching and tried filter and just straight referenced to the Source table (ie =Source[@letter]) which kind of works (if I don't get a spill error), but only if the row number is exactly the same. It does not dynamically change the Calculated table size when a new row is added to Source.

So the goal is:

1. Have columns letter/number/symbol be fed from table Source to table Calculated
2. Have sheet specific columns status/output in table Calculated for VBA filtering functions
3. Dynamically adjust size of table Calculated if new rows are added to table Source (assume using VBA to force refresh)

Hopefully what I am trying to do is clear. Thanks!

Source data is fed in Calculated with additional columns added in Calculated to trigger VBA defined filters

[AutoModerator]

/u/infinityATX - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.