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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Highlighting duplicates 0
Hyperlink to a specific worksheet in another workbook 5
How do I have a cell value define a dynamic named range? 15
Get location of match in another worksheet 2
Excel 2003 - Relocating an entire row of from one worksheet to ano 2
move a row of data from one work sheet to another using a formula 1
reference worksheet name in cell in another worksheet 4

Back
Top