Hello,

I have a spreadsheet that has various columns of data. What I am
trying to do is extract data from one column while leaving the rest of
the data in that column intact. And create a separate column for the
data that I extracted. I have tried recording the macro and
autofiltering out what I needed and trying to paste, but When I go
back to actually run the macro it paste the data in the wrong columns.
Example:

Item Number Description Comment
1 long N/A
2 short EXT
3 medium HM
4 tall INT

I want to create a new column with the (EXT and INT) data only from
the Comment column and rename the comment column something else.
However, the autofilter technique will then paste the results in the
wrong order. Please help if someone out there has a fix to my
situation.

Thanks