Change cell reference

[MrMcLee]

I have several cells that reference a cell on a different worksheet. Everyday this reference will change.

Example: cell A1 might have the referece ='Current Balance'!D1

Tomorrow that reference will be ='Current Balance'!E1.

In other words, the column will change daily, but the row will stay the same.

This code gives me the column I need from the other worksheet, but I can't seem to figure out how to use that info to change the formula.

Please Login or Register  to view this content.

Trying to use the INDIRECT function didn't seem to work either. Someone please point me in the right direction.

[DGagnon]

try using offset, something like this

=OFFSET(Sheet2!B4,0,x)

where x is a referene to how many columns over you need the refference to be.

[MrMcLee]

Guess I didn't even need vba for that one. Thank you, sir!

[DGagnon]

no problem, glad to assist.