VBA Macro Help. Thanks!

[mlibrett]

I'm looking to create a macro that looks down a specified column for 4 different values (something like A, B, C, D) and if those values are there for it to highlight and copy the rows.

Anyone have any idea how to make this?

For example, if I had 20 columns of data, and I want to look down one column called "Country" for only the value USA. But when it sees USA I want it to highlight that entire row and bring it into a new worksheet.

I'm thinking you may be able to use an if statement for this?

 

[venkat1926]

number of such question must have been answered even in this group. I suggest this

1.autofilter whole data for USA in that column
2.highlight filtered data and copy to another location.

as it is that simple no need for a macro.