Hidden data in cells ... where to put it

T

Tim Smet

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
 
F

Frank Kabel

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

Debra Dalgleish

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")
 
Top