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.
|