Copy unique data to a different WS

[Guest]

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

WorkSheet 1
Date Prod ID

 

[Ken Wright]

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
------------------------------­------------------------------­----------------

 

[Guest]

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

 

[Dave Peterson]

You have a reply to your post in .misc.

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