Re: Excel Help Needed
Already tried that BeaucoupFish and it didn't work. It seems if I name a cell the name stays at that location.
ie:
name A1 - "CellOne"
Put some data in that cell like the number "2"
Enter the number "1" in cell A2
Resort the column in Ascending order
"1" is now in A1 and "2" is now in A2
A1 is still named "CellOne"
So names stay with the cell not with the data. I played with that Insert/Name/Define thing till I was ready to bash my keyboard to death. Tried removing the '$' signs in the "Refers to:" box but to no avail.
|