[SOLVED] Apple Numbers Copy and Paste Cell Function

[Streat]

Hello, I was hoping for a bit of guidance creating a function for a cell in numbers. I would like to create a cell that takes any value inputed and copies it into the bottom cell of a particular column in another table. For clarity this is a budget, at the top I am trying to create a series of cells, gas/internet/rent etc. into which I can type the monthly amount that will then take that value and add it to a running table below. If this is in any way unclear please feel free to let me know, thank you for your help!

 

[udit1311]

I'm not entirely sure if this'll help...but you could try the VLOOKUP command as listed here among other options -
http://help.apple.com/functions/mac/5.0/#ffa148e9cd0