Hi all
I'm having a random moment that I think I've simply thought to much about and can't see the answer.
How do you make a cell, say G1 for example in sheet1 the copy paste value of the formula A1 in sheet 2.
If I just use =Sheet2!A1 it simply copies the formula value which causes a circula reference issue.
So what would go into G1 to grab the value only and not the formula?
Cheers
Bookmarks