Question concerning Excell.?

Question

I'm trying to use a block from my first tab in another tab. It's an amount that I was trying to use at the end of my worsheet to show a tally. I can't figure out how to transfer it from one tab to another. Any help out there?

Answer 1

From your first tab (or sheet) select your block and press CTRL+C (copy), then go to your second sheet, select the cell where you want to paste your block, choose edit (from the menu bar) and special paste, and paste link. Like this if you edit your block on the first sheet, it should update the block on the second one as well.

Answer 2

simply copy and paste on other tab it will transfer the formula too