Hi all my boss has just shown me his spreadsheet that he is trying to complete. the problem is that he has used data from other sheets buy cutting and pasting into his new sheet and has come up with a circular reference. i will try and explain:
His sheet current reads
a1 is data manaully inputted
b1 =C1/A1
c1 =A1*B1
My question is can i make c1 formula on read the value in b1 and not the cell reference, any assisatance would be appreciated.
Cheers odd
His sheet current reads
a1 is data manaully inputted
b1 =C1/A1
c1 =A1*B1
My question is can i make c1 formula on read the value in b1 and not the cell reference, any assisatance would be appreciated.
Cheers odd
