I regularly have to compare two spreadsheets of account names to find the
matching values. Each spreadsheet has account names in one columns, but then
other columns will have different info, which I have to merge together if
there are matches.

I usually line up the columns and then color one set red and them put them
into the same worksheet and sort by name and scan visually for matches, then
do a lot of cutting and pasting...

Question #1 - Is there a way to find all the matching values in one column?
Say column A has two instances of Wal-Mart, how can I locate them in 1,000
lines? Is there a way to move them, and their attendant data into another
column or table once I do?

Thanks!