Nitesh Mathur
Member
HI ,
Im using MS Excel 2007 and developing a seating arrangement tool in excel.
In excel file two sheets :
1. Seat availability (Seat vacant or occupied , which I take care through macro)
2. Datavalue : in which Seat no, employee no and employee name is entered (a master table for tool tips).
My requirement is I want to add dynamic tool tip on each seat no , on which Seat No , Employee no and employee name is display as tool tip. And also automatic update whenever I update employee information in "DataValue" sheet.
Sample sheet attached for your reference.
I have added tool tip (manually) on seat no 111, 112 and 113 for reference.
This question I have posted in "Ask a Excel Question" also.
Thanks in advance.
Nitesh
Im using MS Excel 2007 and developing a seating arrangement tool in excel.
In excel file two sheets :
1. Seat availability (Seat vacant or occupied , which I take care through macro)
2. Datavalue : in which Seat no, employee no and employee name is entered (a master table for tool tips).
My requirement is I want to add dynamic tool tip on each seat no , on which Seat No , Employee no and employee name is display as tool tip. And also automatic update whenever I update employee information in "DataValue" sheet.
Sample sheet attached for your reference.
I have added tool tip (manually) on seat no 111, 112 and 113 for reference.
This question I have posted in "Ask a Excel Question" also.
Thanks in advance.
Nitesh