View Single Post
  #1  
Old September 17th, 2009, 07:01 PM posted to microsoft.public.excel.worksheet.functions
Eden397
external usenet poster
 
Posts: 43
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