bacon
New Member
- Joined
- Aug 28, 2008
- Messages
- 22
Hello
I have a list of people names that can change at any time in A:A on data sheet(#1) called ’caseworker’. In E:E on 01/06/15(#2)is a list (data validation) of 1,2,3,4.(call attempts).
On sheet#2 In J3 I have a data validation reference to ‘caseworker’ and would like to show the total amount of calls made by a person in J4 when their name is selected via the dropdown , so I guess J4 is looking at columns A-E down to row 2340.
Data is added constantly.
But can’t do it....
I have a list of people names that can change at any time in A:A on data sheet(#1) called ’caseworker’. In E:E on 01/06/15(#2)is a list (data validation) of 1,2,3,4.(call attempts).
On sheet#2 In J3 I have a data validation reference to ‘caseworker’ and would like to show the total amount of calls made by a person in J4 when their name is selected via the dropdown , so I guess J4 is looking at columns A-E down to row 2340.
Data is added constantly.
But can’t do it....