Im stuck..

Please help..

I have recently put together a call logging system and when people call they have a reference number, lets say 1A, when the call is ended all details obtained are sent to another sheet, these calls are eventually all bought together with hundreds of other calls taken by other users.

From these call details I created a 'Historic call data log' and in order to access them i created a drop down menu which allows you to select a reference number and find out what the call was about, my problem is that some people will call on more than one occasion and if the user wants to find out what the calls were about he would have to click down a list of the same numbers which relate to different dates.

I need something that will search two columns and if it matches my criteria then returns all results found in relation to that reference number..

Hope that makes sense..

Many thanks


Aidenjacks.

i think a sample file with some dummy data would help ..

why don't you use data filtering ?

Hopefully you can now see the attached file, it is a crude copy of what I'm working on.

What i want to do is retrieve information on from sheet1 by typing data in sheet2, say i type 711 Dubai, I want sheet2 to display all calls made by 711 Dubai with corresponding caller details.

I realise i could achieve this by sorting or filtering, however I am attempting to automate the functionality so the user does not have to do it, all i want them to do is use a drop down menu to select the ref & Location and then in cells below a list appears with all call made..

I hope this makes sense and thanks for your time.

Aiden.