Is there a way of editing (copying, moving, pasting, etc.) in AutoFilter without effecting the hidden cells. For example, I have 5 columns, I autofilter the 1st column, I move the data from column 2 to column 3 and data from column 3 to column 2. When the autofilter is turned off, data within the hidden cells also moved. Suggestions?