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
i have not got a clue how to do this thats why i have posted it here
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?
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Posting Permissions
Reply With Quote
