Looking for a good complex VB book

[jphorton]

I already have MR. Excels VBA and Macros for Excel 2010. What i'm looking for is something that will provide me information on how to create an entirely "automated" via a few inputs database.

Example: I have over 2000 Agents in my call center. I want my supervisors to be able to input an agents ID and see the data stored for that agent.

In the long run, I want to have them input a number and have multiple options i.e. Over Avg of peers, What days of week they want to see, Multiple date ranges.

Anyway, if anyone has any suggestions, I would be grateful.

I have Excel 2010

Thanks

 

[Worf]

Hi

I'm not an Access user, but maybe you could consider it.

Anyway, one book I like is John Walkenbach's Excel Power Programming with VBA.

 

[Smitty]

Welcome to the Board!

I'd look at PowerPivot. It works well with ODBC data sources, and you can add Slicers for Agent ID by supervisor.

HTH,