I have a workbook that contains a number of worksheets. Each one has a
unique identifier contained in cell G6. What I want to be able to do
is select a row in another worksheet (in the same workbook) that also
contains the same reference, i.e. "sheet 5" has the unique identifier
BDE127. I want the VB script that runs when I hit the embedded
command button to refer to this identifier and then search for and
select the row in sheet "Data" that contains BDE127 in a cell in
column A.

Any help/suggestions/advice about how to achieve this would be much
appreciated.


--
Cheers

Peter

Remove the INVALID to reply