| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Go to goto - FIND
I just want to go to a certain row that contains data meeting certain
criteria. (Example: =h3). How do I do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Go to goto - FIND
1. In EXCEL 2007 I have entered:-
=h3 - into cell C23. 2. Click out of cell C23 say into cell L19 (this can be any cell). 3. Ctrl F (simultaneously). 4. Find and Replace should launch. 5. Enter:- =h3 - into the Find what: field. 6. Hit Find Next. 7. EXCEL will take you to cell C23. - and so on. Please hit Yes is my comments have helped. Thanks! "Teddy-B" wrote: I just want to go to a certain row that contains data meeting certain criteria. (Example: =h3). How do I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ? IF & GOTO ? | Excel Worksheet Functions | |||
| On error from Find, GoTo E | Excel Discussion (Misc queries) | |||
| Goto or Find a Date in a Sheet | Excel Discussion (Misc queries) | |||
| find the last Fred and goto cell | Excel Worksheet Functions | |||
| If.....Then GoTo....... | Excel Discussion (Misc queries) | |||
Linear Mode
