Macro for Extracting row information into a new tab [Closed]

Report
-
Posts
14376
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
February 28, 2021
-
Hello

I am in need of a macro that will find a name in one column and copy the entire row into a new tab on the same work book.


Ex. For every row that has a "A" in column "D" to be moved to a new tab on the same work book.

A B C D E
1 N n n a n
2 N n n b n
3 N n n a n


Thank you in advance

1 reply

Posts
14376
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
February 28, 2021
4
Do you want to move or to copy the rows?
Do you want the macro to do that for a single value ("A" in your example), or for several values?
How does the macro know that value, and the name of the new tab to create?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!