Matching Text Files

T

Tim

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.
 
A

aaron.kempf

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.
 
B

Bernie Deitrick

Tim,

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

HTH,
Bernie
MS Excel MVP
 
Top