Forum Discussion
NSK-Mar
Nov 17, 2019Copper Contributor
Paste TO visible cells only in a filtered cells only
I want to paste a formula or value in the visible cells of a filtered column. How to go about it? Thanks
Mike_Selman
Apr 01, 2021Copper Contributor
1: Filter on the source items you want moved
2: Fill the destination column with a colour
3: Turn off the filter
4: Sort your destination column by colour
4: Copy>paste the source to destination
5: Clear contents of source cells if you wanted a cut>paste
2: Fill the destination column with a colour
3: Turn off the filter
4: Sort your destination column by colour
4: Copy>paste the source to destination
5: Clear contents of source cells if you wanted a cut>paste
WillTesting718
Sep 01, 2021Copper Contributor
This worked perfectly. Thank you!