How? Transfer columnar totals only from 1 sheet to another?

-
Posts
1333
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
January 23, 2022
-
Sheet 1: several columns of #s, each column totaled. I want to transfer the columnar TOTALS ONLY that were the result of formulae to Sheet 2. How do I do this, please? Thank you.

1 reply

Posts
1333
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
January 23, 2022
243
Hello JC,

You can keep this fairly simple with some simple formulae. For example, if you have a total in cell A20 of Sheet 1 and you need the total transferred to cell A1 of Sheet2, then do this:-

- Click on cell A1, Sheet2 and place the equals symbol (=) in the cell.
- Go back to Sheet1 and click on the total in cell A20. You will see cell A20 high-lighted with "marching ants" around the perimeter of the cell.
- Hit ENTER on your keyboard.
- Go back to Sheet2 and you should now see the total in cell A1. You should also see the simple formula, =Sheet1!A20, in the formula bar. This formula will now remain in A1 and the total will change as the total in Sheet1 changes.

I hope that this helps.

Cheerio,
vcoolio.