OMG! how do I copy certain data from one sheet to another and then sort it.

**boondangman** · 08-10-2012, 02:32 PM

I need only selected data from column A in sheet 2 to be transferred to sheet 1 and then sorted by salesman name automatically.

In Column A in sheet 2 if it says "GSM" then only those rows be transferred to sheet 1 and then sorted by salesman name (Column H).

I have tried VLOOKUP/ ANDIF but will not work correctly.

Please HELP with this I am stuck!

**oeldere** · 08-10-2012, 02:58 PM

Maybe with a pivot table.

**boondangman** · 08-10-2012, 03:26 PM

Never thought of that, Thank you so much.

**oeldere** · 08-10-2012, 03:29 PM

Glad I could help. Thanks for the reply.
If the question is solved, will you mark your question as solved?
If you have (other) questions, on this item, just ask.