Apr 04 2019 12:01 AM
I have references on other worksheets that need to change if the references change position.
Sheet 2, B1 is "3"
Sheet 1, D32 is =Sheet2!B1 =3
if i change position of Sheet 2,B1, at example in C1, and the B1 becomes empty, in the cell D32 the value is 0
thanks
Apr 04 2019 12:08 AM
Apr 04 2019 12:17 AM
actually this problem borns when i organize sheet 2 in alphabetical order
Apr 04 2019 12:20 AM
Apr 04 2019 01:36 AM