Ask Your Question

Can calculated data from one sheet create a row with results on another?

asked 2019-01-07 20:46:43 +0100

Kolvir gravatar image

updated 2019-01-13 02:48:56 +0100

I have a spreadsheet to track various sales. On the main summary sheet I have just a description, amount and source of sale(like ebay or local). Another sheet I use to calculate my net from ebay sales, with calculations for ebay and paypal fees and shipping charges and costs. I have another sheet for a different site.

Currently if I sell something on ebay I enter the data on the ebay sheet to calculate the net, and then manually enter the description and net on the main summary sheet. What I wonder is if it is possible to have the net, description, and source(ebay in this case) automatically entered/transferred to the summary sheet. I'm willing to research how to write a macro for this, but need to know if it is even possible.

edit retag flag offensive close merge delete


Should I do this in a database instead?

Kolvir gravatar imageKolvir ( 2019-01-13 03:16:36 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-01-07 22:07:55 +0100

erAck gravatar image

You can reference cells or cell ranges from other sheets by specifying the sheet name in a formula expression's cell reference, best prefixed with a $ character for an absolute sheet reference in case you want to copy&paste such formulas to other sheets as well, for example $Sheet2.A1 or $Sheet2.C1:C3. If the sheet name contains blanks or other special characters it needs to be enclosed in single quotes, $'Second Sheet'.A1 and if a name contains a single quote that needs to be doubled to be escaped, as in $'Shop''s Sheet'.A1

edit flag offensive delete link more


That I know, but can I enter data on one sheet and have it fill data on another? I don't have just one cell I want updated, I want a new row populated.

Kolvir gravatar imageKolvir ( 2019-01-08 04:32:09 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-01-07 20:46:43 +0100

Seen: 25 times

Last updated: Jan 13