Hi,
I am trying to match/cross reference (check by ZIP CODE) two extremely
large databases/spreadsheets in MS EXCEL. The vast majority of matches
will turn up negative (no match) and only like <5% of all the
rows/fields in my 31000+ excel sheet will actually match by zip to the
records contained in another sheet (actually this second sheet is a
large Seibel Sales database that I exported to Excel for easier
access/manipulation) So it would be very tedious and a time waster to
manually match the records by hand. My question would be, is there an
automated way in Excel (or using any number of Excel addons such as
ASAP Utilities etc) that would let the computer do the work for me??
Basically I have two large records, one that I exported from Siebel
online to Excel, and the second one is the original work Excel database
that I am to work on (ie find matches by zip code and mark them as
matched)
Is there a quick way to do this? The power of the computer should
really be put to use, but I just don't know /cant figure out how to go
about this.
Any ideas would be helpful, thanks!
BTW here is the screenshots and explainations if you don't know what I
am talking about
:
http://www.freewebs.com/bxc2739/
-Bo
--
bxc2739
------------------------------------------------------------------------
bxc2739's Profile:
http://www.excelforum.com/member.php...o&userid=32538
View this thread:
http://www.excelforum.com/showthread...hreadid=534995