Not sure if I completely follow.
If the list of names is in an Excel worksheet and the matching results
in the cell being selected, then I'd set it up as follows:
Select Case ActiveCell.Column
Case 2 'column B
Sheets(1).Select
Case 3 'column C
Sheets(2).Select
(and so on...)
End Select
On 18 Sep 2003 20:56:58 -0700,
(Tim M.) wrote:
How would I go to Sheet1, Sheet2 or Sheet3 in a database of names with
32 rows, 17 columns? If a name I find a match for is in Column B, go
to Sheet1, if a name is in Column C go to Sheet2, etc. (I need to
start from Column B) My lookup value will be a name, not a cell
reference. Thanks.