Hi All,

i am in need of some help, i am a good user of excel 7, although my skills are a little below the skill level i need to complete the following task. and any help would be appreaciated.. Or even better, if someone is willing to complete this for me all the better

ok.

i have an excel spreadsheet with two sheets, the first sheet is as follows.

Column 1 - a number i allocate
Column 2 - Address postcode
Column 3 - Address street
Column 4 - House numbers in postcode
Column 5 - total number of houses in postcode.

sheet two is as follows

column 1 - Persons Name
Column 2 - Persons allocated number
Column 3 - Total allocated houses

now at the moment i am doing this manually but would like to set the sheet up so it does it itself..

when i allocate a number to sheet 1 column 1, i need sheet 2 column 3 to add up.

in other words, i need sheet 2 column 3, to look at sheet one, and anywhere that

column 1 sheet 1 = column 2 sheet 2

Add together all of column 5 sheet 1, and put the result in column 3 sheet 2

i hope i have explained that.. if not here is a quick example

sheet 1

3 TS1 4PG Aire Street ,,MIDDLESBROUGH 51-97,48-106 54
8 TS1 4PQ Aire Street ,,MIDDLESBROUGH 3-49,2-46,46a 48
3 TS1 4NW Chester Street ,,MIDDLESBROUGH 1-33,2-32 33
8 TS1 3GA Constantine Court ,,MIDDLESBROUGH 1-11,15-73,2-74 73
8 TS1 4PH Costa Street ,,MIDDLESBROUGH 3-51,2-50 50
8 TS1 4PJ Costa Street ,,MIDDLESBROUGH 53-113 31
3 TS1 4PL Costa Street ,,MIDDLESBROUGH 52-122 36
8 TS1 4QJ Crescent Road ,,MIDDLESBROUGH 2-14,18-36,38-42:16/FLAT{1,2,3,4}:18/FLAT{2,3,4,5,6,7,8,9} 30
8 TS1 4QN Crescent Road ,,MIDDLESBROUGH 1-23 12
8 TS1 4QP Crescent Road ,,MIDDLESBROUGH 41-69,46-54,58-72,46a:56/FLAT{1,2,3} 32


Sheet 2

keith appleby 3 131

any help would be appreciated

thank you

keith