How do I accumulate data in sheet Y upon clicking a button in sheet X?

[AlexVX]

Hi there,

I would like to add the current value of a cell (Quantity) in “Sheet X” to a corresponding cell in “Sheet Y” upon clicking a button, to create a running total of various “Objects”. I currently input the data in batches and then manually delete the “Quantity” column until the next batch of data is input.

Current set-up in “Sheet X”:

Object A - Quantity - Price
Object B - Quantity - Price
Object C - Quantity - Price
etc…

What is the most efficient way to do this and do let me know if further explanation is required, I’m pretty new to spreadsheets overall.

Thanks in advance.

[Lupp]

This is a bit hard to understand for me.

1. Why do you use the term “accumulate” which has no unambiguous meaning in spredsheets.
2. In what way is your “corresponding cell” corresponding?
3. The spreadsheet way to work with a value entered (by pasting a “batch” probably) into SheetX in a different SheetY is to put a formula into the “corresponding cell in SheetY” referencing the “original cell in SheetX” like in =SheetX.B34 . Depending on the case it may be preferrable to use the reference as a part (sub-expresion) inside of a larger formula.
4. Assuming you actually already knew what I told here, it may nonetheless help you to understand where I have problems with understading your question.
5. Why do you think a clickable button would be useful in your case?

[Villeroy]

@Lupp

This is a bit hard to understand for me.

He describes a database form.