Looking for a little help. other platforms and google searches say this isnt possible and offer formula work-arounds. Maybe someone one here will know something i cant seem to find. I have a filtered spreadsheet where i need to copy the filtered column X (value returned via formula) and paste special values only into same filtered column Z. i keep getting errors. excel is trying to paste the formula instead of values. it isnt lining the rows back up presumably because of the hidden filtered rows. maybe there is a VBA solution?