Linking two sheets (Excel 2000)

[db49ers]

I have two sheets in a workbook that I want to link and I need some help. Sheet1 will be input and Sheet2 will compute entries.
Sheet1 will have the following:
Column B are dates
Column C are vendors
Column D are dollar amounts
where Rows would be like:
1/1/2002,Dell,$50.00
1/1/2002,Gateway,$100.00
1/2/2002,Dell,$100.00
1/2/2002,Dell,$75.00
Sheet2 will have the following:
A1: 2002
B1: =WEEKDAY(DATE(A1,B2,0))
A2: January
B2: =MATCH(A2,fullyear,0)
Column A are dates but will change if the year is changed:
A11: =IF($B$1=1,DATE($A$1,$B$2,1),"")
A12: =IF(A11="",IF($B$1=2,DATE($A$1,$B$2,1),""),A11+1)
A13: =IF(A12="",IF($B$1=3,DATE($A$1,$B$2,1),""),A12+1)
Row10 are vendors:
B10: Dell
C10: Gateway
What I want to do is have Sheet2 put Sheet1 entries in the correct spot:
B11: nothing
B12: $50.00
C12: $100.00
B13: $175.00
I thought conditional formatting would do it but it will not do it for different sheets.
Thanks for any help! David

 

[db49ers]

Got it figured out! I had to use SUMPRODUCT.