Re: Question combining spreadsheets

From: Bernie Deitrick (_at_)
Date: 11/23/04 

Date: Tue, 23 Nov 2004 14:17:51 -0500

Paul,

Take a look at the VLOOKUP function, and use it to look up information keyed
to your common name. If your common name is in column A, and you want to
extract all the data from workbook 2 named "Workbook 2", on a *** named
"Data ***", with the data table in cells A1:G100

=VLOOKUP($A1,'[Workbook 2.xls]Data ***'!$A$1:$G$100,COLUMN(A1)+1,FALSE)

Copy to the right for another 6 columns, and down to match your key fields.

HTH,
Bernie
MS Excel MVP

<Paul> wrote in message news:eF7NjQY0EHA.2804@TK2MSFTNGP15.phx.gbl...
> I have two spreadsheets with a common field, being user name. I would
like
> to somehow automate combining these. One does have more users than the
> other.
>
> Is it possible (macros or something else) to do a search for a name from
> xls1 in xls2, then grab data next to that name from xls2 and put it back
in
> xls1.
>
> TIA,
> Paul
>
>