Macro Help!

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
I need a macro that will select all rows that have have the word "Japan" in one of the columns. And then Copy and Paste that to Another sheet and then delete the original rows. I'm brand new to macros and having troubles understanding how I would do that.

Thanks!

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
You can record the macro

All you need is filter on "contains" and look for Japan in the filter

copy the rows

delete the rows

remove filter
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month