Matching Text Files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to take the addresses from sheet 2 and add them to sheet 1.
The data I work with is almost 50,000 records long or I would just copy and
past, or sort, filter or something.

I'm trying to find a vba way to match up the names from sheet 2 and then add
the addressed to the same names on sheet 1.

Any ideas?

Thx in advance.
 
throw excel out the window and use a DATABASE. Excel can't handle more
than 64k records; and it'll bog down way before that.

good luck, I strongly reccomend MS SQL SERVER.
 
Tim,

Try using a VLOOKUP formula, with False as the last parameter. Help has some very good examples.

HTH,
Bernie
MS Excel MVP
 
Back
Top