Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
paste data over hidden cells that are filtered | Excel Worksheet Functions | |||
drag data vertically over hidden cells.. ignore hidden cells | Excel Discussion (Misc queries) | |||
pasting data on hidden cells | Excel Discussion (Misc queries) | |||
Linking Cells with Hidden Data | Excel Discussion (Misc queries) | |||
pasting data over hidden cells | Excel Worksheet Functions |