Copy Specific Data
 

I have one worksheet named "Data" that is basically a database of information
for up to 20 representatives. Each representative may be named several times
throughout the worksheet in column B.

I need a macro that will copy any row with Representative #1's name and all
the information in that row to a worksheet that has been named for that
specific representative, adding each additional row below the first with no
blank rows.

I need to do the same for Representative #2, and so on. There may or may
not be 20 representatives at any given time and so I don't want a specified
number of sheets/representatives to be designated.

I want to do the same thing copying data that was entered for a certain
month (the date field is column A) to a worksheet that has been named Jan08,
Feb08, Mar08, etc.

Ultimately, I want any data for a specific representative to be copied to a
sheet named for that representative and any data entered in a specific month
to be copied to a sheet named for that month.

I hope that makes sense.

Thank you so much in advance!

Copy Specific Data
 

Hi Chersie,

The first port of call for operations involving
filtering or copying data between worksheets
should be Ron de Bruin's estimable site:

http://www.rondebruin.nl/

More particularly, for your requirement,
see Rons code at:

Create a new sheet for all Unique values or
paste it below the existing data if the sheet exists
http://www.rondebruin.nl/copy5.htm#Add



---
Regards.
Norman


"Chersie" wrote in message
...
I have one worksheet named "Data" that is basically a database of
information
for up to 20 representatives. Each representative may be named several
times
throughout the worksheet in column B.

I need a macro that will copy any row with Representative #1's name and
all
the information in that row to a worksheet that has been named for that
specific representative, adding each additional row below the first with
no
blank rows.

I need to do the same for Representative #2, and so on. There may or may
not be 20 representatives at any given time and so I don't want a
specified
number of sheets/representatives to be designated.

I want to do the same thing copying data that was entered for a certain
month (the date field is column A) to a worksheet that has been named
Jan08,
Feb08, Mar08, etc.

Ultimately, I want any data for a specific representative to be copied to
a
sheet named for that representative and any data entered in a specific
month
to be copied to a sheet named for that month.

I hope that makes sense.

Thank you so much in advance!

Copy Specific Data
 

Hi Norman,

Thank you for your response. I am working at setting this up and I think it
will work just fine for most of my situation.

I am not sure however how to get it to work for my months of Jan08, Feb08,
etc. The reason being is that column A will have dates such as 1/17/08,
etc., and not the worksheet tab name. I need something that will say, if the
date in column A is within the month of January, copy that row's data to the
worksheet named Jan08, and on and on. I hope this makes sense and you can
assist me with this!

Thanks again,

"Norman Jones" wrote:

Hi Chersie,

The first port of call for operations involving
filtering or copying data between worksheets
should be Ron de Bruin's estimable site:

http://www.rondebruin.nl/

More particularly, for your requirement,
see Rons code at:

Create a new sheet for all Unique values or
paste it below the existing data if the sheet exists
http://www.rondebruin.nl/copy5.htm#Add



---
Regards.
Norman


"Chersie" wrote in message
...
I have one worksheet named "Data" that is basically a database of
information
for up to 20 representatives. Each representative may be named several
times
throughout the worksheet in column B.

I need a macro that will copy any row with Representative #1's name and
all
the information in that row to a worksheet that has been named for that
specific representative, adding each additional row below the first with
no
blank rows.

I need to do the same for Representative #2, and so on. There may or may
not be 20 representatives at any given time and so I don't want a
specified
number of sheets/representatives to be designated.

I want to do the same thing copying data that was entered for a certain
month (the date field is column A) to a worksheet that has been named
Jan08,
Feb08, Mar08, etc.

Ultimately, I want any data for a specific representative to be copied to
a
sheet named for that representative and any data entered in a specific
month
to be copied to a sheet named for that month.

I hope that makes sense.

Thank you so much in advance!

Copy Specific Data
 

Autofilter for Jan and copy autofilter for feb and copy ,etc
OR
use a for/each loop if not too big

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Chersie" wrote in message
...
Hi Norman,

Thank you for your response. I am working at setting this up and I think
it
will work just fine for most of my situation.

I am not sure however how to get it to work for my months of Jan08, Feb08,
etc. The reason being is that column A will have dates such as 1/17/08,
etc., and not the worksheet tab name. I need something that will say, if
the
date in column A is within the month of January, copy that row's data to
the
worksheet named Jan08, and on and on. I hope this makes sense and you can
assist me with this!

Thanks again,

"Norman Jones" wrote:

Hi Chersie,

The first port of call for operations involving
filtering or copying data between worksheets
should be Ron de Bruin's estimable site:

http://www.rondebruin.nl/

More particularly, for your requirement,
see Rons code at:

Create a new sheet for all Unique values or
paste it below the existing data if the sheet exists
http://www.rondebruin.nl/copy5.htm#Add



---
Regards.
Norman


"Chersie" wrote in message
...
I have one worksheet named "Data" that is basically a database of
information
for up to 20 representatives. Each representative may be named several
times
throughout the worksheet in column B.

I need a macro that will copy any row with Representative #1's name and
all
the information in that row to a worksheet that has been named for that
specific representative, adding each additional row below the first
with
no
blank rows.

I need to do the same for Representative #2, and so on. There may or
may
not be 20 representatives at any given time and so I don't want a
specified
number of sheets/representatives to be designated.

I want to do the same thing copying data that was entered for a certain
month (the date field is column A) to a worksheet that has been named
Jan08,
Feb08, Mar08, etc.

Ultimately, I want any data for a specific representative to be copied
to
a
sheet named for that representative and any data entered in a specific
month
to be copied to a sheet named for that month.

I hope that makes sense.

Thank you so much in advance!

Copy Specific Data
 

You can use this add-in to filter on month/year
http://www.rondebruin.nl/easyfilter.htm

Or add a helper column in your data

=TEXT(MONTH(A1),"mmm")& YEAR(A1)

You can filter on that column then



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Chersie" wrote in message ...
Hi Norman,

Thank you for your response. I am working at setting this up and I think it
will work just fine for most of my situation.

I am not sure however how to get it to work for my months of Jan08, Feb08,
etc. The reason being is that column A will have dates such as 1/17/08,
etc., and not the worksheet tab name. I need something that will say, if the
date in column A is within the month of January, copy that row's data to the
worksheet named Jan08, and on and on. I hope this makes sense and you can
assist me with this!

Thanks again,

"Norman Jones" wrote:

Hi Chersie,

The first port of call for operations involving
filtering or copying data between worksheets
should be Ron de Bruin's estimable site:

http://www.rondebruin.nl/

More particularly, for your requirement,
see Rons code at:

Create a new sheet for all Unique values or
paste it below the existing data if the sheet exists
http://www.rondebruin.nl/copy5.htm#Add



---
Regards.
Norman


"Chersie" wrote in message
...
I have one worksheet named "Data" that is basically a database of
information
for up to 20 representatives. Each representative may be named several
times
throughout the worksheet in column B.

I need a macro that will copy any row with Representative #1's name and
all
the information in that row to a worksheet that has been named for that
specific representative, adding each additional row below the first with
no
blank rows.

I need to do the same for Representative #2, and so on. There may or may
not be 20 representatives at any given time and so I don't want a
specified
number of sheets/representatives to be designated.

I want to do the same thing copying data that was entered for a certain
month (the date field is column A) to a worksheet that has been named
Jan08,
Feb08, Mar08, etc.

Ultimately, I want any data for a specific representative to be copied to
a
sheet named for that representative and any data entered in a specific
month
to be copied to a sheet named for that month.

I hope that makes sense.

Thank you so much in advance!