Hi everyone,

I have been looking for hours on the net for a solution to my problem and I couldn't find any, although I am sure there is one and it must be dead simple...

Here is my issue:
On one sheet, I have a referenced table called Table1, let's say the rows are for Salespersons and the columns are for their monthly sales. On the last column of the table I have the Yearly sales of every salesperson just by adding up the values in each column for every salesperson.

Now I would just like to create a summary worksheet (different from the first one) on which I would just display the first and last columns of my referenced table (the names of the salespersons and their yearly sales). I would need this summary table to update size-wise should I want to add a salesperson, that's why I am pretty sure the solution is to use referenced columns here or something like that.
I have tried many things like =Table1([@Salesperson]) or =Table1([Salesperson]:[Salesperson]) but it keeps returning the VALUE error.

My main goal here is to have my summary table update automatically (size-wise) should I want to expand my original table.

I would rather avoid a VBA solution if possible as I have never used VBA before and I don't feel very comfortable with using it.


Thank you very much in advance for your help