Hi,

I have two worksheets in the same book.
Sheet 1
ID / Course / Description / Amount
01/PH 101 /Basic PR / $200
01/PH 102 /Inter PR / $50
02/GD 203 /Basic Gd / $150
03/L 301 /Travel / $250
03/SC 401 / Science /$100
etc...
Sheet 2
ID /Base /Addition /Total
01 /$250 /$0 /$250
02 /$150 /$0 /$150
03 /$100 /$250 /$350

What I want to create is:
ID / Course / Description / Amount /Base /Addition /Total
01/PH 101 /Basic PR / $200 /$250 /$0 /$250
01/PH 102 /Inter PR / $50
02/GD 203 /Basic Gd / $150 /$150 /$0 /$150
03/L 301 /Travel / $250 /$100 /$250 /$350
03/SC 401 / Science /$100

Please note the values in sheet 2 show up only once. Can I do this? How?

Thank you.