| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to calc an intersection
I need to write a macro that calculates fringe in a
spreadsheet whenever Forecast and Fringe intersect. A B C D Jan Feb Mar Account Actual Forecast Forecast 1 Salary 100,000 95,000 92,000 2 Fringe 28,000 +95,000* .2 +92,000*.2 The formula that I need in C2 and D2 is Salary * FringeRate. How can I write a macro that calculates this ... Whenever Fringe and Forecast intersect calculate fringe in that cell. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MACRO can I calc just one line? | Excel Discussion (Misc queries) | |||
| 2Q:Indirect worksheet selection in macro, Calc off for specific sh | Excel Discussion (Misc queries) | |||
| Calc cost pro rata (nested IF's and macro to find empty row) | Excel Worksheet Functions | |||
| auto calc on, but have to edit (f2) cells to force re-calc..help! | Excel Worksheet Functions | |||
| calc locks up after running a macro that moves sheets to a new fil | Excel Discussion (Misc queries) | |||
Threaded Mode
