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.

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

On Tue, 24 Nov 2009 07:20:01 -0800, Nikki
wrote:

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.

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.
--
jb


"Nikki" wrote:

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.