Hi,

I have a table in my excel doc in sheet 1. The table is named "table1" and has M columns and around 20 rows. New rows will be added over time.

I want to create a copy of this table in another sheet call it "Sheet 2" with some of the columns removed. I want it such that if the main table is updated/new rows added the second table is updated accordingly.

How can this be done?

Thank you for your time and help.