Ok, I don't exactly know what to call this and I've spent hours and hours trying to find it on my own.
I have a bunch of cells that all reference the same row and need to be updated each month. For instance, changing each one from "13" to "14" then next month to "15". So A13, B13, C13, D13 etc. all need to be updated to A14, B14, C14, D14, and so on. I planned to use another cell elsewhere with that number in it, then each month I can update the one cell that says "13" to "14" etc. How can I do this? Or is there a better way?
Also, if it makes a difference, these will also be referring to another sheet, but I figured it wouldn't make a difference and I could hopefully adapt it as such.
Thank you so much in advance!
David
I have a bunch of cells that all reference the same row and need to be updated each month. For instance, changing each one from "13" to "14" then next month to "15". So A13, B13, C13, D13 etc. all need to be updated to A14, B14, C14, D14, and so on. I planned to use another cell elsewhere with that number in it, then each month I can update the one cell that says "13" to "14" etc. How can I do this? Or is there a better way?
Also, if it makes a difference, these will also be referring to another sheet, but I figured it wouldn't make a difference and I could hopefully adapt it as such.
Thank you so much in advance!
David