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,
How can I copy data in a filtered range into one of the columns next to it?
thanks,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@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.
=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