Question combining spreadsheets

[Guest]

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

 

[Bernie Deitrick]

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 sheet named
"Data Sheet", with the data table in cells A1:G100

=VLOOKUP($A1,'[Workbook 2.xls]Data Sheet'!$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