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
Bookmarks