PDA

View Full Version : % movement tracker macro



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

keilah
04-04-2008, 06:51 AM
i have not got a clue how to do this thats why i have posted it here

Aussiebear
04-04-2008, 03:38 PM
Hi keilah, Can you post a sample workbook?

You asked " 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%...." , and at this stage given the information supplied we can only assume the values are numerical, but... is that difference a + or - value, or is E7 or F7 the greater value?

You also asked "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)......". Are we looking a a different sheet to that which you initially refered to?