Can I copy a sheet and keep values from a Count IF statement?
Is there a simple way I can copy a sheet where I need to remove links but keep the values as is? These values were derived from a COUNT IF statement on the original sheet and when I save a copy removing links, I get an INVALID error in that cell on the copied sheet, which makes sense since it is not able to count anything without the link in my formula.
I was thinking of having an extra column that copies the value and that value does carry over into the copied sheet. I could hide that copied column in original sheet (I don't need to see it there) and then do the reverse in my "Archive" sheet, namely hide the COUNT IF column (with INVALID due to no more links) and show column with copied value to keep a record of those values.
This will add a bunch of hidden columns which isn't a huge deal but I was wondering if there was a simpler way to be able to save that information?
Hope this makes sense.
Thanks in advance!