keilah
04-04-2008, 05:33 AM
Hi experts
Need a macro that picks up percentage movements between a range of cell say E7:F20.....i.e if the difference between f7 - e7 exceeds 10%....
i need the macro to to input the cell reference and percentage movement value in a worksheet 'summary' into cells c7 (cell ref) and D7 (% value)......
this has to bee done via the macro function as there are already too many formula in the work book slowing it down......
Thanks
Need a macro that picks up percentage movements between a range of cell say E7:F20.....i.e if the difference between f7 - e7 exceeds 10%....
i need the macro to to input the cell reference and percentage movement value in a worksheet 'summary' into cells c7 (cell ref) and D7 (% value)......
this has to bee done via the macro function as there are already too many formula in the work book slowing it down......
Thanks