Previous Topic Next Topic

Macro Help!

Closed
MacroHelf - May 26, 2010 at 03:42 PM
rizvisa1 Posts 4478 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 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

Automatically Run Macro from a calculated cell value change
smiller -
TrowaD -

1 response
Execute Macro On Calculated Cell change
Notar -
rizvisa1 -

5 responses
Code for macro that conditionally inserts rows
bfleming -
bfleming -

4 responses
How to convert number into text in Excel
boratechandu -
Raj -

9 responses