new to macros
Posted by saradhi on March 28, 2001 2:48 AM
I am new to macros in excel and programming in VB as such.
I need help with macros in excel. My problem is the following.
1. I have three columns of data in which I have to find a specific value say 149 in column 3...
2. Then I need to modify the cell in column B below the target cell ( containing 149) as = cell value + cell value - previous cell value. now called X.
3. then I need to update the other cells below it
in column B as X +existing value...( column B )
until I find the next 149.
I know the flow chart for this program but cant find help on VB comands to achieve this as macro for excel.
I would realy appreciate help with this.
thanks a buch for the help.. in advance.