Home

Tansferring sum total onto a new tab

Highlighted
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.
Highlighted

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

Highlighted
figured it out!!