Tansferring sum total onto a new tab

New Contributor

Oce i have calculated a sum it gives me a total; which changes when the information in the equation changes. But I need to transfer that changeable cell onto a new tab, if anyone understands this how do I do it?

3 Replies
Just cut and paste those cells in new sheet. or copy and paste special as linked cells.

I have copy and pasted the cells but when the total on the first tab changes, it doesn't change on the second tab?

figured it out!!