Macro Using 'FIND' function across several worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Back
Top