Macro Help

[Nikki]

I have one workbook of data (1 tab) that has data for 20 different Sales Reps
(different names). I need to copy all data for "Rep A" into a separate
worksheet, and same for "Rep B" and so on. At the end I would have 1 tab for
all data and 20 tabs with the data for each rep. Basically, I need to copy
and paste each rep data into a new worksheet within the same workbook but
didn't want to do it manually. I hope this makes sense.

 

[Gord Dibben]

See Ron de Bruin's site for code.

http://www.rondebruin.nl/copy5.htm

Also check out his easyfilter add-in.

http://www.rondebruin.nl/easyfilter.htm


Gord Dibben MS Excel MVP

 

[john]

Nikki,
have a look at this site:
http://www.contextures.com/excelfiles.html

there is a sample workbook (FL0013) you can download that does more or less
what you want.