On Dec 13, 1:08*pm, Simon Lloyd
wrote:
It sounds like you just need to create a simple matrix with a userform
as the query tool ---- In what way are the current workbooks
disjointed?, how do you currently query the data? what terms/conditions
are needed to display the data? is there common data between them?

--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile:http://www.thecodecage.com/forumz/member.php?userid=1
View this thread:http://www.thecodecage.com/forumz/sh...ad.php?t=40542

Thanks to all who responded. I appreciate you taking the time.
Everyone made some great points so I'll touch on them and hopefully my
responses will help you narrow things down for me.

Otto--I get your point about consolidating into one workbook. Ideally
that would be great. But my workstation is hardly ideal. 256MB ram
with a Celeron processor, and a T1 connection so slow it can take,
literally, 45-50 seconds just to open ONE of my workbooks (I timed
it!!). And that workbook has only 3500+ rows by 10 columns of data.
Yes, I do have a fair number of Sumproduct formulas working in it but
adding more data would slow it down even more.

Socko--a great list of sites--thank you!!!!! I routinely use 75% of
them. The others I don't know about, but I will surely investigate.

Simon--you intrigue me with your statement "simple matrix with a
userform as a query tool". I've used userforms only rarely in the
past, but I'm fuzzy on what you mean by "matrix".

What I need is a way, an easy idiot proof point and click way that my
bosses can gather info from the data I have stored. To illustrate,
when I tried to show them how to get their answers easily by using
Auto Filter you would have thought I asked for a dissertation on
E=MCsquared.

I asked about using a userform on one of the forums Socko mentioned.
The responses I received led me to believe this would be particularly
difficult to use.

I use pivot tables once in a while, but asking/teaching them to use
one is even beyond a simple autofilter.

Here is an example database I have. It is for tracking our doctor
referrals. I enter the drs name, and how many referrals for each
site. There are also 2 different referrals they can make to the site-
PT or OT. It looks something like this:

DrName Month Year Site1 PT Site1 OT Site2 PT Site2 OT etc
(there are 5 sites)

I need an easy way for a non geek to ask "how many PT referrals did
Dr. X make to site 3 in January 2007?" or "how many referrals did Dr C
make to Site 5 in the first 6 months of 2008?'.

I'm sorry if I've droned way too long. I'm trying to be as clear as
possible.

Thanks again for your help.

Don