I think what your asking is for the 'note' (insert>note) functionality to contain a lookup to the first sheet based on the number in the cell (on sheet 2).
Typically the formula would be something like a vlookup, but I don't believe you can embed these into 'notes'. One suggestion would be to create a column with the vlookup formula on the second sheet then hide that column so it does not get messed with or altered. HTH, Paul . On Apr 11, 2005 10:53 PM, Chadley Wilson <[EMAIL PROTECTED]> wrote: > Greetings > > I would like to create an alias for names in a spread sheet, > in other words > > In cell A3 I have a name and in cell B3 I have the number "1" > In cell A4 I have a name and in cell B4 I have the number "2" > > In the second sheet I have the numbers of all the names instead of the names, > > What I require is that feature where you hold the mouse over a cell and a > little speach bubble type thing appears with a description or notes on that > cell, only if on sheet 2 I hold it over the relevant cell with the number it > must popup the persons name, that is linked to the number, therefore as my > staff chop and changed I can just edit the name and the number links the rest > of the sheets formulas. > > Hope someone understands what I mean ;) > > TIA > Chad > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
