Hi, i have a range of data in AG3:AG14, each month i copy the formula in the last row with data (i.e AG7) to the next row below i.e (AG8) and then copy and paste as values the cells above. How can i automate this with a macro?
let me know if any further info is required. i.e below - i want to copy the formula (which gives me 138%) into the next available row and then copy and paste the above cell as a value. i do this once a month.
Jan-13 159%
Feb-13 120%
Mar-13 113%
Apr-13 107%
May-13 138%
Jun-13
Jul-13
Aug-13
Sep-13
Oct-13
Nov-13
Dec-13
Bookmarks