I need to deliver a demo to a client that will eventually be web based if we get the gig, but for now a proof of concept using Excel, ideally without macros, etc.
First I have a Summary page with various categories listed and a count of how many are within the category. What I need then is if a category is clicked either a pop up window comes up with prepositioned data associated with the category or a text window. Client will not accept macros. Only four categories, but the results page could include several hundred line items, so manually creating Comment boxes is not practical. I have been experimenting with hyperlinks, but cannot get a range to show up, only one line in the named range.