| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Cells.find to find first number in a row which is 8000 | Excel Discussion (Misc queries) | |||
| How to find same number in different cell of Worksheet? | Excel Discussion (Misc queries) | |||
| find the frequency a number appears with another number within a s | Excel Worksheet Functions | |||
| countif formula to find the occurances of a number that is greater than one number but less than another | Excel Discussion (Misc queries) | |||
| How do I find how often a number appears within a worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
