It's been a long time since I made daily use of excel, and if I knew how to do this, I have forgotten how. I have messed with this off and on for the last day, and I can't make it do what I want it to.
I have a workbook with 4 worksheets in it. On WS3, I have a column that totals in a single cell.
Right now, I am having to manually transfer that total (just the numbers, not the formula that created the total) over to WS4, where I want it to go into a single cell that will get added together with other things.
I don't want to have to manually transfer it, as a) I am lazy and b) I transpose numbers a lot, and don't want to screw it up.
Everything I have tried thus far copies the formula that was used to create the original total on WS3, not just the number that represents the total.
Suggestions?