Macro to search for and display data in another worksheet
 

Hi all

I would like a macro to be able to take data from an adjacent cell
(non-specific, so if i apply the macro to a "button" it selects the data from
that particular adjacent cell) in e.g. "Worksheet1" and search for the same
value in another worksheet e.g. "Worksheet 2". Then be taken to Worksheet 2
to view the data found which contains this value (if possible, this worksheet
will only show the data relevant).

The data from the cell in worksheet 1 will have multiple rows in worksheet 2.

I have text examples i have entered into worksheet 1 each row is named by a
serial number, worksheet 2 contains all the test data which in the first
column will contain the relevant serial next to the data. Each of the test
examples will have multiple rows of data in worksheet 2.

Hope this makes sense. Basically i want to navigate to the data (worksheet
2) from the test examples (worksheet 1).

Cheers

Mark