I can't copy and past when I'm using a filtered list.
I've got only some rows showing in my list.
It won't let me copy and paste. I'm trying to copy a filtered column,
(meaning only selected rows, say 1, 4, 7, 8, 50, 54)
and then paste the values of those rows on top of it after I no longer need
the formula.

The error messge I keep getting is:
the copy area and the paste are are not the same shape.
Try one of the following: click a single cell,
Select a rectangle that's the same size and shape and then paste.

or error message:
The command cannot be used on multiple selections.

Any tips, explanations, or fixes?