Excel data extraction using VB

[Andr3s]

Buenas tardes

Dear friends
Im workin on a telecom company "Movistar" and my boss charged me a damned hard task
i have an Excel file "database" with this info

Date | Login | ANI | Status
01-07 T452236 5263 Ok
01-07 T452236 7896 Nok
01-07 T452236 1236 OK
01-07 T233325 5321 Nok
01-07 T233325 12 OK
01-07 T122363 1365 OK

i have an other sheet where i specify the Date and Login and i want make excel answer me with a list of ANIs the login (T452236) did in (01-07) As i know theres no way to make it using excel options (Formulas) so Plz i need a VB script to do it
Exp:
A1=T452236
B1=01-07
Answer:
A2=5263
A3=7896
A4=1236
A5=#NA ...
Sorry for my bad english ^^ i really need help :S or my boss gonna kick my ... THx ya all ``

 

[Smitty]

Welcome to the Board!

I'd look at a Pivot Table. The helpfile has some good documentation on them.

 

[Andr3s]

Welcome to the Board!

I'd look at a Pivot Table. The helpfile has some good documentation on them.

I dont wanna make it using "Pivot Tables" coz the system has to work AUTO just specifying the Date & Login

thx

 

[Smitty]

You can automate Pivot Tables. There's no point in trying to recreate in code what a pivot table can do natively, so why not see if it gives you the result you expect before dismissing it?

 

[Andr3s]

I tryed using Pivot tables But Date and Login has to be changed Manualy on the Table and not on the Sheet i created
and Pivot tables Values (Date & Login) Can not be tooken fron An other Sheet