how to copy a filter range to another column

Dear excel experts,

How can I copy data in a filtered range into one of the columns next to it?

thanks,

Microsoft Excel

Last Comment

Rob Henson

8/22/2022 - Mon

Rob Henson

9/20/2016

With the filter in place, start in the first visible cell of the column where you want the copy with a formula:

=B2 assuming data coming from column B and first row is row 2

Then highlight down to the bottom of the destination column and use Ctrl + D to fill down; this will only populate in the visible cells.

Now remove the filter and highlight the column. Copy and paste values to break the links.

Thanks
Rob H

ASKER CERTIFIED SOLUTION

Yamaafg

9/20/2016

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

Rob Henson