Hidden data in cells ... where to put it
 

Hi,

I need to put some hidden data that needs to be linked to a cell so that it
moves with the cell and even copies with it. I have thought about putting it
in the comment but that would not allow the user to use any other comments
in the same worksheet. Any ideas ???

Kind Regards

Tim Smet

Hidden data in cells ... where to put it
 

Hi
IMHO comments are the only way to go. don't see another
chance to store values with a cell

-----Original Message-----
Hi,

I need to put some hidden data that needs to be linked to
a cell so that it
moves with the cell and even copies with it. I have
thought about putting it
in the comment but that would not allow the user to use
any other comments
in the same worksheet. Any ideas ???

Kind Regards

Tim Smet


.

Hidden data in cells ... where to put it
 

You can use the N function to add text that is visible in the formula
bar only. For example:
=95+N("This is my hidden comment")
or
=SUM(B1:B16)+N("This is another hidden comment")

Tim Smet wrote:
I need to put some hidden data that needs to be linked to a cell so that it
moves with the cell and even copies with it. I have thought about putting it
in the comment but that would not allow the user to use any other comments
in the same worksheet. Any ideas ???


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html