Copy Contents of a Cell Address

**johnathanamber** · 10-14-2009, 02:42 PM

Hey everyone!

OK so I am making a check registry for my wife and I to use and update as needed.

I have a cell labeled "Current Bank Amount (Cell Address: K3)".

I want this cell to display the contents of cell address K4 at all times, even if it is updated or if a new row is added above K4.

How can I do this?

God bless,
Johnathan

**ncmay** · 10-14-2009, 03:09 PM

Account Register 07 04 09.xls might be helpful at the site below.

http://sites.google.com/site/normay/excel-files

**johnathanamber** · 10-14-2009, 04:15 PM

ncmay,

Thanks for that. Although I didn't see what I was looking for.

Does it make sense in my original post?

I simply want the value of a cell address to be displayed in another cell.

And I want to use the static cell address and not the cell by itself. This way if the previous cell moves, i.e. a new row above is created, then the value is always updated.

God bless,
Johnathan

**ncmay** · 10-14-2009, 04:34 PM

Can you post a sample workbook and show an example?

**NBVC** · 10-14-2009, 04:38 PM

Maybe you mean:

=Index(K:K,4)

so if your previous K4 is now K5, then you will get the new K4.

**johnathanamber** · 10-14-2009, 05:42 PM

NBVC,

Thank you so much... that is exactly what I was looking for.

It works great.

Thank you and God bless,
Johnathan

**NBVC** · 10-14-2009, 05:53 PM

Please remember to mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save