Link to home
Start Free TrialLog in
Avatar of tony01excel tony
tony01excel tony

asked on

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,
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

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
Avatar of Yamaafg
Yamaafg

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
@Yamaafg - well done, that does it; as doing Ctrl + D only affects the visible cells I should have realised that Ctrl + R would do the same.