Macro for Extracting row information into a new tab Closed

Question

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

yg_be · Answer

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?

Macro for Extracting row information into a new tab

1 response

Similar discussions

Subscribe To Our Newsletter!