Mel Smith
Well-known Member
- Joined
- Dec 13, 2005
- Messages
- 1,023
- Office Version
- 365
- Platform
- Windows
Hello folks,
On my spreadsheet I have 60 staff with various data entries for each one over four lines. Their names are in cells AH5, AH9, AH13 and so on to AH241.
What I am trying to achieve is to have a search facility that will locate any selected member of staff and that cell become the 'focused' cell. Can anyone suggest the best way to achieve this, please?
Many thanks.
Mel
On my spreadsheet I have 60 staff with various data entries for each one over four lines. Their names are in cells AH5, AH9, AH13 and so on to AH241.
What I am trying to achieve is to have a search facility that will locate any selected member of staff and that cell become the 'focused' cell. Can anyone suggest the best way to achieve this, please?
Many thanks.
Mel