Excel VBA extracting data

G

Goldie

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top