Find a number on another worksheet
 

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?

Find a number on another worksheet
 

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
---
"Heath" wrote:
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?