| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Using 'FIND' function across several worksheets
Hello,
I'd like to write a macro so the user can run a macro that will: 1) ask the user to input a value 2) search for the value in the current worksheet 3) if the value is not found, move to the next worksheet and continue search 4) if the value is not found, move to the next worksheet and continue search (etc.) I know in Excel I hit 'Ctrl' + 'F' and enter the value, then click 'Search'. If I get the message that no values are found, I hit 'Ctrl' + 'PgDn' to move to the next sheet (etc.). We have upwards of 20+ worksheets in each workbook and it takes forever to manually move between sheets. Can anyone help? -- Thank you! - Jennifer |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro Using 'FIND' function across several worksheets
If you do "select all" on the worksheet tab, all sheets will be searched
from Ctrl+F. Jennifer Cali wrote: Hello, I'd like to write a macro so the user can run a macro that will: 1) ask the user to input a value 2) search for the value in the current worksheet 3) if the value is not found, move to the next worksheet and continue search 4) if the value is not found, move to the next worksheet and continue search (etc.) I know in Excel I hit 'Ctrl' + 'F' and enter the value, then click 'Search'. If I get the message that no values are found, I hit 'Ctrl' + 'PgDn' to move to the next sheet (etc.). We have upwards of 20+ worksheets in each workbook and it takes forever to manually move between sheets. Can anyone help? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro Using 'FIND' function across several worksheets
You could also use Jan Karel Pieterse's FlexFind:
http://www.oaltd.co.uk/MVP/ (The feature that Bob I suggested was added in xl2002, IIRC.) Jennifer Cali wrote: Hello, I'd like to write a macro so the user can run a macro that will: 1) ask the user to input a value 2) search for the value in the current worksheet 3) if the value is not found, move to the next worksheet and continue search 4) if the value is not found, move to the next worksheet and continue search (etc.) I know in Excel I hit 'Ctrl' + 'F' and enter the value, then click 'Search'. If I get the message that no values are found, I hit 'Ctrl' + 'PgDn' to move to the next sheet (etc.). We have upwards of 20+ worksheets in each workbook and it takes forever to manually move between sheets. Can anyone help? -- Thank you! - Jennifer -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I create a macro that works like the "find' function | Excel Discussion (Misc queries) | |||
| Find text - worksheet function or macro? | Excel Discussion (Misc queries) | |||
| Function to find difference between two similar worksheets is miss | Excel Discussion (Misc queries) | |||
| Find function in a macro | Excel Worksheet Functions | |||
| Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
Linear Mode
