Excel Question #46

[Moonliner]

Originally Posted by Kevy Baby

I found a better to resolve for #2: I had the client provide me with records already suppressed to the month of April

Well, yes, this might be a better tool. But then I would have to purchase and learn said new tool. If 95% of what I need to transport can be covered by a pickup truck, I am not going to buy a semi-truck and get a class A license for that other 5% - I'll just make a couple of extra trips as needed.

Besides, I got to learn how to make a lookup table today!

Purchase is not a problem, if you have excel you probably already have Microsoft Access in house. That's all you would need. If not, MySQL (Which runs this site) is free for the downloading albeit with a somewhat higher learning curve than Access.

[Kevy Baby]

Originally Posted by Moonliner

Purchase is not a problem, if you have excel you probably already have Microsoft Access in house. That's all you would need.

Since I am, for the moment, still running on Office 2003, I have no Access. Alas, much to my chagrin, I am updating to Office 2007 Professional (the disk was just placed on my desk), so I have it will soon.

I have been reticent to move to 2007 as it seems that everything has been moved in Excel. But I need to be only three years out of date and not seven (we do get a free upgrade to 2010 as well).

[Moonliner]

Originally Posted by Kevy Baby

Since I am, for the moment, still running on Office 2003, I have no Access. Alas, much to my chagrin, I am updating to Office 2007 Professional (the disk was just placed on my desk), so I have it will soon.

I have been reticent to move to 2007 as it seems that everything has been moved in Excel. But I need to be only three years out of date and not seven (we do get a free upgrade to 2010 as well).

I ran the beta of Word 2010 for awhile. I was less than impressed it struck me as a big step backwards in usability. Be sure to take a long look at it before you leap, free might be too high of a price to pay.


As for 2007 the "Ribbon" interface is not that bad. Just remember to look at the tabs across the top and think which one best fits what you are trying to do. Chances are that's were you will find it.