Macro for Extracting row information into a new tab

Closed
Rose - Nov 10, 2016 at 05:10 PM
yg_be Posts 22694 Registration date Sunday June 8, 2008 Status Contributor Last seen April 17, 2024 - Nov 11, 2016 at 07:03 AM
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
Related:

1 response

yg_be Posts 22694 Registration date Sunday June 8, 2008 Status Contributor Last seen April 17, 2024 5
Nov 11, 2016 at 07:03 AM
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?
0