View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eden397 Eden397 is offline
external usenet poster
 
Posts: 40
Default Showing all data related to the quantity in one cell

Hi,
I am trying to find a way of showing all the data in a popup type of form
when I hover over a cell. Lets say I have 2 worksheets in one overall
workbook. In tab A in cell A1 I have a sumif quantity of 43. I want to
hover over A1 and show all rows of data in my second tab B. Is there a way
to do this? Thanks