phendrena
10-14-2008, 09:23 AM
Hi,
I've got two worksheets setup : Data and Summary
In the data sheet there is a list of inbound contacts, a list of contact numbers and a list of why they called.
In the summary sheet i need to create a dynamic list that will show :
Contact | Number | Total Of Why Called | Reason 1 | Reason 2 | Reason 3 |
The Contact & Number fields will contain duplicate entries in the data sheet as people can call multiple times.
The Summary should therefore only list these details once.
The third column, Total Of Why Called would then give a total of how many times they have called.
Reason 1/2/3 would then show how many times the person has called based on what has been entered into the Why Called column (Reason 1/2/3)
Can anyone suggest a good why of doing with VBA.
Thanks,
I've got two worksheets setup : Data and Summary
In the data sheet there is a list of inbound contacts, a list of contact numbers and a list of why they called.
In the summary sheet i need to create a dynamic list that will show :
Contact | Number | Total Of Why Called | Reason 1 | Reason 2 | Reason 3 |
The Contact & Number fields will contain duplicate entries in the data sheet as people can call multiple times.
The Summary should therefore only list these details once.
The third column, Total Of Why Called would then give a total of how many times they have called.
Reason 1/2/3 would then show how many times the person has called based on what has been entered into the Why Called column (Reason 1/2/3)
Can anyone suggest a good why of doing with VBA.
Thanks,