$$Excel-Macros$$ Re: Automatic Update to formula after selecting a different category in a drop down list

2010-12-16 Thread dailem
There are several different ways to approach this, but without using VBA I would suggest the following: 1) create your category drop-down list in a cell using the validation tool in excel. 2) in a part of your worksheet that won't be used create a list of all your budget categories that are in yo

$$Excel-Macros$$ Problem w/ VBA Code Evaluating a Range

2010-01-18 Thread dailem
I'm relatively new to VBA programming, but what I want to do is go through a range starting at a10 through the last record listed (varies in # of records, but always together). If the field in column a = "cogs", then I want to count it as +1. Eventually I'm trying to create to sum formulas- one t