Any time you filter, enter a reference towards the copied column labels in the Duplicate to box. The copied rows will then involve just the columns for which you copied the labels. We could utilize the excel shortcut keys Ctrl + Change + L to use filters into the column https://torqueconverterclutch34555.59bloggers.com/34147792/little-known-facts-about-auto-filter