Previous Topic Next Topic

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

Closed
JC - Jan 10, 2022 at 02:06 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Jan 10, 2022 at 10:04 PM
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.
Related:

1 response

Answer 1 / 1
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 259
Jan 10, 2022 at 10:04 PM
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.
0