display cell information

chaoticneutral

New member
Joined
Dec 20, 2013
Messages
2
Reaction score
0
Points
0
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?
 
is a cell, say, G7, on the first page only checking the other G7 cells on the other pages?
 
yes that's correct, Roll up front page.png and example.png 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:
Back
Top