List Management

[Earofcorn]

I have 2 lists. One contains locations and the other contains items. Each item can be found in a few specific locations, and each location contains a few specific items. I'd like to create a user-friendly document where someone can mouse over a location and see a list of the items there OR mouse over an item to see a list of the locations it can be found at. This is a long list so how can I do this using excel's functions?

As a side note: I've seen lists where when a cursor hovers over an item in one column, the items it corresponds to in another column are highlighted, I'd also like to know how that's done.

 

[williamgowtama]

This is done by using macro and formula.
on the macro vba side, create a module and put this code

Public Function Hover()
 ActiveSheet.Range("A1").Value = "you hover a cell"
'put code for getting the other column's value
End Function

then on the formula side (the cell that you want to enable it to hover)

=IFERROR(HYPERLINK(Hover(),""), "ItemA")

Hope it helps