Hi all,

Was just wondering if it is possible to search an entire workbook for data which a user has input in say cell A1 on Sheet 1 (or a textbox), and then have them click on a 'search' button located next to the cell to find the data and take them to the cell where it's located? This sounds easy I know but I've spent all day trying to figure out how to do it and not having a great deal of experience with macros am having a bit of trouble!

Hopefully it's clear what I'm after but I'll reiterate:

- Data input by user in cell A1 (or textbox whichever is easier!)
- 'Search' button clicked after data entered
- User is taken to worksheet where that data is located and cell is highlighted

Any and all help very much appreciated.

Lock-e73 ;Þ