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