Need a pop up of a range of cell values or to copy same to a new tab in Excel 2010
Posted on 2014-03-03
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.