I have formula set to multiply (in this instance) number of guest attending and the price per plate. On another sheet, I am keeping track of all expenses involved in the event to stay withhin budget. As RSVPs come in, I update sheet A (which updates the total price). Is there any way to make this transfer to sheet "B" to also update the price there too?
2007-03-27 11:23:11 · 2 answers · asked by AntDU 5 in Computers & Internet ➔ Software
When I cut & Paste the cell with the formula I get "REF" and nothing occurs.
2007-03-27 11:38:54 · update #1
Type =sum(
click the whole column of the other spreadsheet)
This will give you a formula that looks like this
=SUM([Book4]Sheet1!$A:$A)
Make sure you click on the whole column, this way it will add as the rsvp comes in. Do not create totals as this will result in double counting.
2007-03-27 17:09:41 · answer #1 · answered by unnga 6 · 0⤊ 0⤋
Copy the cell, which will just copy the formula, then paste it into the cell in the other sheet. I forgot what this is called, but it has a special name.
If that doesnt work, then i dont know.
Hope that helps.
2007-03-27 18:32:05 · answer #2 · answered by Anonymous · 0⤊ 0⤋