Copy unique data to a different WS
 

This is my situation any suggestion or help will be greatly appreciated.

WorkSheet 1
Date Prod ID

Copy unique data to a different WS
 

A bit more detail would help.

Is this a one time operation, or something that needs to be live and linked
in some way.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Sdbenn90" wrote in message
...
This is my situation any suggestion or help will be greatly appreciated.

WorkSheet 1
Date Prod ID

Copy unique data to a different WS
 

Date Prod Id Customer Amount
1/2 B123 John Doe 5
1/2 B123 Jane Doe 4
1/3 G456 John Smith 5
1/4 S789 Jane Smith 4

I need a formula, function, or Macro to do the following: resulting in WS 2
Copy unique Prod Id (ex. B123 is listed twice but I only need it displayed
once on WS 2 with the amount of both as displayed). This to help track sales
of a product quarterly. Also can this be done automatically.

Result for Worksheet 2
Prod ID Jan Feb Mar
B123 9 0 0
G456 5 0 0
S789 4 0 0

"Ken Wright" wrote:

A bit more detail would help.

Is this a one time operation, or something that needs to be live and linked
in some way.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------Â*------------------------------Â*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------Â*------------------------------Â*----------------


"Sdbenn90" wrote in message
...
This is my situation any suggestion or help will be greatly appreciated.

WorkSheet 1
Date Prod ID

Copy unique data to a different WS
 

You have a reply to your post in .misc.

Sdbenn90 wrote:

Date Prod Id Customer Amount
1/2 B123 John Doe 5
1/2 B123 Jane Doe 4
1/3 G456 John Smith 5
1/4 S789 Jane Smith 4

I need a formula, function, or Macro to do the following: resulting in WS 2
Copy unique Prod Id (ex. B123 is listed twice but I only need it displayed
once on WS 2 with the amount of both as displayed). This to help track sales
of a product quarterly. Also can this be done automatically.

Result for Worksheet 2
Prod ID Jan Feb Mar
B123 9 0 0
G456 5 0 0
S789 4 0 0

"Ken Wright" wrote:

A bit more detail would help.

Is this a one time operation, or something that needs to be live and linked
in some way.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------Â*------------------------------Â*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------Â*------------------------------Â*----------------


"Sdbenn90" wrote in message
...
This is my situation any suggestion or help will be greatly appreciated.

WorkSheet 1
Date Prod ID




--

Dave Peterson