help to automate finding records

  • Thread starter Thread starter dangtran09
  • Start date Start date
D

dangtran09

I currently have a spreadsheet with 1 column called contrac
number(text). It has about 60 records.

I have a list of numbers in a word document which I like to compare i
to the spreadsheet. Right now, I'm manually going into the list an
copying the number and do a Find on the spreadsheet to see if it is i
there. If it is, I would copy that number to another word document.

My question is: how do I automate this to have that document with al
the numbers to check to see if those numbers are in the spreadsheet an
copy that number into a new doc?

Does this make sense? Please help. Thanks in advance
 
As an excel user, I'd dump word and do all my work in excel <bg>.

I'd copy that list from word into a new worksheet.

Then I'd use some techniques for working with duplicates from Chip Pearson's
site:
http://www.cpearson.com/excel/duplicat.htm

Then once I isolated those numbers, I'd copy back to MSWord.

If the existing numbers were in column A of sheet1 and I added the list from the
word document to column A of sheet2, I'd use this formula in column B of sheet2
(the word doc list):

=isnumber(match(a2,sheet1!a:a,0))
(in B2 -- headers in row 1)

And drag down.

Then apply data|filter|autofilter to column B and show only the Falses.

Then copy those visible cells in column A back to a new MSWord document.

(if you don't want a table when you paste into MSWord, you can:
edit|paste special|unformatted text.
 
Back
Top