Formula Help

[jaaakez99]

Not sure how to describe this problem. I want a formula that updates the Cell, "Beginning Balance:Current Balance" as more rows are added with new dates and correpsonding dollar amounts. Its the cell below with the REF error, and the Cur. Bal. should be over it. I just cant make the table look quite right. Any suggestions?

Cur. Bal. 1/8/2010 1/22/2010
Beg. Bal. #REF! $ 2,000 $ 3,000

[lucas]

Hi jaakez, we have no way of knowing what the formula is in that cell

can you clue us in?

You can attach your workbook by going advanced and scroll down till you find manage attachments.

remove any real data and show us the problem with notes.

[jaaakez99]

not sure I did it right

[jaaakez99]

can you see the attachment?

[Bob Phillips]

Nope!

[jaaakez99]

attachment should be included.

[jaaakez99]

thanks anyway

[Bob Phillips]

Try

=INDIRECT(ADDRESS(ROW(),$B$1))

[jaaakez99]

WORKED, THANKS!!!!!!!!!!!!!!!!!!!!!!!