Hope someone can help.
I need a macro that will take a user-entered serial number & then use the Find command to search entire workbook for a match. I would then like to store the sheet name and/or cell reference of the first match.
Can this be done?
Rgds,
MacGrizz
I need a macro that will take a user-entered serial number & then use the Find command to search entire workbook for a match. I would then like to store the sheet name and/or cell reference of the first match.
Can this be done?
Rgds,
MacGrizz