Hi,
I'm trying to manage a lot of information on a large spreadsheet which tracks what standard of parts have been fitted to a product. This is essentially a huge matrix of part codes (so, for example, there might be five different versions of one part) which compares the fitted standard to an 'ideal standard'. Fairly simple in itself, the problem is there's so much information that showing both the part 'code' and the part description on one sheet is impossible.
I'd like to set the sheet up such that it only shows part numbers, but if a particular part number is hovered over, the description of the part is shown (like a comment). There are thousands of parts and their descriptions change, so I can't manually write comments each time. What I'd really like is a master sheet in the background which details each part, and then something which will go away and look for a description in that backsheet when I hover over a particular code. Is this possible?
I've attached an example sheet if that helps. In this example I'd want to be able to hover over the code 'SLN113' in the matrix and the comment to read "Sleeve - Life limited - 200hrs" - taken from the datasheet on the seperate tab. Is this feasible??
I'd really appreciate anyone's help. If it helps I'm using Windows 7, Excel 2010 and am a complete novice with User Defined Functions...
Thanks in advance!!
AlAttachment 203472
Bookmarks