Jim,sounds like your going to need a hunk of V B A for this if it can be done in excel, I'm not sure if it can or not, but I do believe that access can do all you wish, have you considered using it?
if you want to keep trying for it in excel, you might go get the V B A tutorials on my Jamal's documentation page at the grab bag, it may give you some help with this.
good luck, inthane. For Blind Programming assistance, Information, Useful Programs, and Links to Jamal Mazrui's Text tutorial packages and Applications, visit me at:
http://grabbag.alacorncomputer.com. to be able to view a simple programming project in several programming languages, visit the Fruit basket demo site at:
http://fruitbasketdemo.alacorncomputer.com . for a blind user friendly Chat, go take a look at: http://www.icedirc.com/----- Original Message ----- From: <james.homme@xxxxxxxxxxxx>
To: <programmingblind@xxxxxxxxxxxxx> Sent: Wednesday, July 09, 2008 10:47 AM Subject: MS Office - Excel Questions
Hi, Please forgive me if this is off topic. I'd like to get an idea if array formulas will help me with a problem in Excel. First, I need to understand how they work. Secondly, here is the problem. In a work sheet, I have a column of data that I want to use for categories. On another sheet, I formatted a column so that it contains a drop down list that picks from the column in the first sheet. Here's the issue. I want to add to a total that corresponds to whatever category Ihappen to pick. For example, if the category in a cell is baseball tickets,I want to add to that total. If the category is clothes, I want to add to that one. I would very much like to avoid summing categories even if theyhave zero values. By that, I mean that I don't want to have to have a sheetthat has a row for every single category. I just want to add to a category total if I pick it. Besides all of that, I want to roll up everything into daily, weekly, and monthly totals only for the categories I use. I don't even know if all of this is possible. If this is the wrong list to talk about this on, where can I take the question? Thanks. Jim James D Homme, Usability Engineering, Highmark Inc., james.homme@xxxxxxxxxxxx, 412-544-1810 "it is only possible to live happily ever after on a day-to-day basis." -- Margaret Bonnano Highmark internal only: For usability and accessibility: http://highwire.highmark.com/sites/iwov/hwt093/ __________ View the list's information and change your settings at //www.freelists.org/list/programmingblind
__________View the list's information and change your settings at //www.freelists.org/list/programmingblind