Quite difficult to use VLOOKUP without specifying a lookup value and lookup
table.

Can you explain what you mean by "auto-select"?

Normally one would type =VLOOKUP(value, then switch to source sheet,
select the table, type any arguments, add a closing parens then hit ENTER key.

What part of this needs automating?

Can you explain what you mean by "automatically do a vlookup between two data
lists in two sheets with a single step"?


Gord Dibben MS Excel MVP

On Fri, 10 Dec 2010 08:31:00 -0800 (PST), Dave K wrote:

Is anyone aware of VBA code that would allow me to auto-select the
previously active worksheet (within a particular workbook....or within
another open workbook)?

In essence, I am trying to build a routine that will allow me to
automatically do a vlookup between two data lists in two sheets with a
single step, rather than go through the process of specifying the
particular columns

Thanks for any suggestions.

FYI, i am using Excel 2003.