Copy Pasting Range From Data Filter

[Haroon]

Hey Guys,

First post here.

I am working on a worksheet that has 5 columns of data (equal values in each)

Once the data is filtered manually, it would be nice to see the single row (after data filter selection) only, separately, in a different worksheet, at a designated location

How can I do this?

Thanks

 

[Somendra Misra]

Hi,

Welcome to the forum.

Can you share a sample file illustrating what you want?

Regards,

 

[jeffreyweir]

Using PivotTables and Slicers would probably let you do this.

 

[Haroon]

Hi,

Welcome to the forum.

Can you share a sample file illustrating what you want?

Regards,

Somendra pls find attached an xls file, from the first filter please select the value '2'. you will get just one row shown now.. I would like this one row shown/displayed separately in another worksheet.

The xls i sent you has bogus values for the sake of understanding how this works.