Recent content by dstein

Skip - FANTASTIC! Works like a charm and then some. I've managed to create similar tables for my company's Conf Calling, Calling Card, and Cell Phone expenses (which are tracked in different tabs and each have slightly different layouts). Now I'm going to mess around and see if I can come...

Skip - while prepping this response I see you've offered another suggestion using MS Query. I haven't yet looked at your response to get my hands around it, but will do so in a few minutes. Following is an extract of the first 3 rows and first 2 months of my current sheet. Extend out...

Man, I love this user community! Skip - thanks for the reply. I'm trying to take the general lessons of your post/faq and fit it into my situation. My confusion right now is that my source data isn't quite in the simple format of LAST JAN FEB MAR last1 234 123...

Well, this group of experts hasn't failed me yet, so here's another puzzler (at least to me). Apologies at the outset if I'm using the wrong terminology for certain things. Background: I am tracking monthly telephone expenses for users. For any random month, the user belongs to a specific...

Thanks to all for the ideas - some really creative thoughts, and definitely some cool stuff for me to dig further into. In this particular case the idea of normalizing the data in order to use a pivot table might not work well for this particular application, as the data to be normalized is...

I need to do the following lookup: Given Name ('blah1'), return the Dept# that Name belonged to during a certain month. Both Name and the month are known at time of lookup. In essence, I'd like to do a VLOOKUP that also has some kind of AND function in it, passing Name as an argument but only...

We just received and have begun installing our S-Box (safe@Office version). At the moment, we do NOT yet have an operating tunnel with our NG FP2 system. Here's early comments: (I consider myself an extremely experienced installer of CP and CP-compatible solutions. I've successfully...