updating one cell value using values from another worksheet
Posted on 2010-11-19
I'm creating a family budget with google spread sheets.
I've gotten helped with a big chunk and now I believe I'm on the final stage.
I have a spread sheet where I collect data under the following headers:
Timestamp | Description | Purchase Type | Expense | Deposite | Balance
My second sheet is from a Budget template that I found in google and is got all sorts of options for expenses types.
My idea is to bring values from the first google sheet into specific cells in my second sheet(Budget sheet). Example:
The budget sheet has a something like this: Fun Cash: (cell for projected) | (cell for actual). Inside the cell for actual I would like values from the first spread sheet of "Purchase Type=Fun Cash" to add themselves inside that cell, so if I add 5 entries of type "fun cash" of 20 then my "Fun Cash actual column in my Budget sheet" would update to 100.
After a lot of googling I've only figure it out how to bring 1 specif cell from my first sheet into my Budget sheet like this
=importrange("MY_SHEET_ID", "CELL_COL_AND_NUMBER") ... but obviously this not what I want.
Is what I'm after possible?