M
Martin
I have multiple tables on one sheet--one table is what I
call the master sheet, where I move cell entries around
regularly. In my other tables, I enter the cell that I
always want it to show the data. How do I make the cell
absolutley never change?
Example: In M1 I put in "=A1". In M1 I now have whatever
is in A1. But if I move the information in A1 somewhere
else and it is now blank, M1 still has the same
information in it. Because A1 is now blank, I want M1 to
be blank also. How do I do this?
I am sure this is a simple thing to do, but I cannot
figure out how to do it. Thank you for your help.
call the master sheet, where I move cell entries around
regularly. In my other tables, I enter the cell that I
always want it to show the data. How do I make the cell
absolutley never change?
Example: In M1 I put in "=A1". In M1 I now have whatever
is in A1. But if I move the information in A1 somewhere
else and it is now blank, M1 still has the same
information in it. Because A1 is now blank, I want M1 to
be blank also. How do I do this?
I am sure this is a simple thing to do, but I cannot
figure out how to do it. Thank you for your help.