Macro Help!

Closed
MacroHelf - May 26, 2010 at 03:42 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- May 26, 2010 at 04:17 PM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
May 26, 2010 at 04:17 PM
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