hi all,
i am after a macro to transfer data from one sheet to another based on a column. Please see attached
So i have 6 sheets
Complete Data (master)
here i will cut and paste or add more rows when i get the information comes in. i would say i would have around 500 rows max
in Column F i give the person a catergory.
once i select that catergory i would like the whole row of that information to transfer to that catagory sheet
example: i place Unknown 1 in Column F, that goes to unknown 1 sheet
Hope that makes sense
Bookmarks