A macro to link a comment with the contents of a cell

[Discipulus]

Hi there,

I've got an excel spreadsheet with 2 tabs. The first tab is a dashboard, which basically has a map of a storage yard with all the different container units.

The second tab contains all the data. i.e. the customers name, mobile number, date due and etc.

I'm looking for a way to show a summary of information about a customer when you hover over a cell. E.g. in the dashboard tab if I hover over cell A17 (which refers to say container 21) then I would want a comment to appear which has the following info:

Customer name: ....
Customer Mobile #:
Due Date: .....

So this comment box would need to be linked with my second tab i.e. the tab with all the data. It would need to be linked with the cell contents and the comment box in the dashboard would need to update whenever changes are made to this data.

I hope this makes sense. I would appreciate any assistance

Thanks,

Dan

 

[L. Howard]

Hi Dan,

You're welcome, glad it works well for you.

Howard