P
Phil H.
MS Excel 2003, Workbook name “2008 Results.â€
In worksheet named “Inventory,†Column M has alpha-numeric codes - the
worksheet contains 8000+ rows.
In worksheet named “Function Codes,†365 a-n codes are held in column B,
with their corresponding text descriptions in column C.
What is needed: when the user hovers the cursor over a cell in “Inventoryâ€
column M, Excel finds the a-n code in worksheet “Function Codes†column B,
and displays the corresponding text from column C the same way as in a
hyperlink “Screen Tip.â€
Finally, the user must be able to click on a column M cell, make an a-n code
change, and the new text description appear when hovering over the changed
cell (after the correction has been entered).
What would the macro code be and where would it be placed?
In worksheet named “Inventory,†Column M has alpha-numeric codes - the
worksheet contains 8000+ rows.
In worksheet named “Function Codes,†365 a-n codes are held in column B,
with their corresponding text descriptions in column C.
What is needed: when the user hovers the cursor over a cell in “Inventoryâ€
column M, Excel finds the a-n code in worksheet “Function Codes†column B,
and displays the corresponding text from column C the same way as in a
hyperlink “Screen Tip.â€
Finally, the user must be able to click on a column M cell, make an a-n code
change, and the new text description appear when hovering over the changed
cell (after the correction has been entered).
What would the macro code be and where would it be placed?