0

I am wanting to enter a bunch of cell references that are affected by a change in only one of them. On one sheet tab, I have a list of dates in column C, and dollar figures in both D and E. In another sheet tab, I want to have a cell that reflects the first date on the original tab. Then in another 2 cells, the dollar figures related to that date. But I want to be able to just change the cell referencing the date to the next date and have the dollar figures do the same as per the date cell. Kind of like this:

This cell is referencing the date cell (=Sheet1!C3) Then for the dollar cells (=Sheet1!(C+1)3) - so that the reference ends up being for cell D3.

I also want to be able to do that for the row (=Sheet1C(3+1)) - so it is actually meaning C4.

I hope that makes sense!

0

(=Sheet1!(C+1)3) - so that the reference ends up being for cell D3

=INDIRECT("Sheet1!"&ADDRESS(3, 3+ROW(A1), 4))

(=Sheet1C(3+1)) - so it is actually meaning C4

=INDIRECT("Sheet1!"&ADDRESS(3+COLUMN(A1), 3, 4))

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.