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