How can I automate changing a cell's reference.
Posted by Greg Vincent on March 06, 2001 11:59 AM
Ok, here's what I need to do, but I can't figure it out
for the life of me. I have a row of cells all refering
to cells A1 through Z1 in another sheet. Every week,
I need to update them by one (i.e. first week updated
to A2....Z2,next week to A3...Z3, etc.). How do I do this?
I've been trying to write a macro, but it will update from
1 to 2, but not 2 to 3, or 3 to 4 and so on.