This video is in response to a question from a viewer who wanted to copy specific columns from one table to another table and have the copy update automatically if the original data changes.

In the video I cover 2 methods: The CHOOSECOLS function, which is only available to Microsoft 365 users and the little-known Camera Tool which, although is more long-winded, is available in all versions of Excel.

The formula I used was: =CHOOSECOLS(IceCream,1,3,5)


Preparing the Worksheet


The Camera Tool