Results 1 to 3 of 3

Thread: display cell information

  1. #1

    display cell information

    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have a 6 page spreadsheet with hundreds of prices on each page. The first page is a roll up page that displays the lowest value of the cell from pages 2-5 using the MIN function. Is there a way to display what page the information came from on the roll up page either when I mouse over it or by color or by selection of that cell?

  2. #2
    is a cell, say, G7, on the first page only checking the other G7 cells on the other pages?

  3. #3
    yes that's correct, Click image for larger version. 

Name:	Roll up front page.png 
Views:	5 
Size:	86.3 KB 
ID:	1923 and Click image for larger version. 

Name:	example.png 
Views:	3 
Size:	88.5 KB 
ID:	1924 so as you can see, ill be pulling prices to the same cell from each of the corresponding pages onto the front page
    Last edited by chaoticneutral; 2013-12-23 at 06:21 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts