Find a number on another worksheet

  • Thread starter Thread starter Heath
  • Start date Start date
H

Heath

I want to create a cell that I can repeatedly type a number in and it will
find and take me to that number on another worksheet in the same workbook.
Is this possible?
 
One easy way is simply to use the "Find and Replace" functionality
In the leftmost sheet, just do a CTRL+F to surface the dialog, choose
Within: Workbook. Enter the number to find > click Find Next (& repeat-click
to browse right through the sheet/all sheets)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
 
Back
Top