Dear Excel gurus,
In our rather small church cemetery, we currently have an EXCEL Worksheet containing those owners of cemetery plots that are either "occupied", "sold but not occupied" and those that are still for sale. A few of the cells are concatenated to show [ie. John Smith, interned 12 Jan 2018]. On another tab, we have a mock up map of the cemetery with one cell equaling one plot. What I'd like to do by some method [ hover ? screen tip? pop up? hyperlink, comment] is with the cursor on the map, either automatically or by clicking on the cell, show the concatenated data from the other tab to know who owns or is in the cell [ or plot in this case] [ie John Smith]. Does that make sense? Any direction would be greatly appreciated.
Best regards,
Rob
In our rather small church cemetery, we currently have an EXCEL Worksheet containing those owners of cemetery plots that are either "occupied", "sold but not occupied" and those that are still for sale. A few of the cells are concatenated to show [ie. John Smith, interned 12 Jan 2018]. On another tab, we have a mock up map of the cemetery with one cell equaling one plot. What I'd like to do by some method [ hover ? screen tip? pop up? hyperlink, comment] is with the cursor on the map, either automatically or by clicking on the cell, show the concatenated data from the other tab to know who owns or is in the cell [ or plot in this case] [ie John Smith]. Does that make sense? Any direction would be greatly appreciated.
Best regards,
Rob
