copy in filter mode

G

Guest

Is there a way to copy a range for cells from one column to another while in
filter mode. Using a copy paste give erratic results.
In addition is there a way while in filter mode to copy a formula down the
filtered cells without affecting the hidden cells

Thank you

Harry
 
D

Dave Peterson

For the second part, I just use the fill handle and drag down and it seems to
work nicely.

For the first part, maybe you can use formulas.

With the range filtered, you could use something like:
=d3
(and drag down)
to copy from column D.
Or even =if(d3="","",d3)

Then if you want you could show all the data and copy|paste special values.

(if you don't have any formulas in that other column that need to be saved.)
 
Top