Comparing, Sorting,countig Mac address and vendor names
 

Hello,
I have a list of @6000 mac address in excel sheet. I am trying to writ
a macro to compare the mac addr to iee
URL=http://standards.ieee.org/regauth/oui/oui.txt]oui.txt[/url]

I am have tried to go thur tutorial ans was able to wire a macro t
extract the 1st 6 digits from the mac-address, manually sorted it an
now I would like to find the occurance of unique 1st-6digit
of the address and then compare it to the oui.txt list to get th
vendor names.

Thanks

--
Message posted from http://www.ExcelForum.com

Comparing, Sorting,countig Mac address and vendor names
 

I tried the Preview feature and lost the attachment, here it is ...

here is the Macro I wrote to extract the 1st-6 digits of the MA
address for caomparision to the vendor list
-----------------
Option Explicit

Private Sub Analyse_Click()
Dim i As Integer

For i = 1 To 5000
Sheet1.Cells(i, "B") = Left(Sheet1.Cells(i, "A"), 6)

Next i
End Sub
------------------------------

Its not letting me uploadt a 200kb file...well
the column A had all the mac address...for testing purposes..here are
few
0000c5099510
0000c509a113
0000c509b995
0000c509b9f8
0000d12094a1
0001034db20b
0001034db4b8
000103794995
000124701cd3
00012480477f
0001248060ac
000124806101
00012480731e
000124809752
00012480b8bb
00012480d38e
00012480f5d0
000124811b1d
000124812453
00012481672e
000124819605
00012481b2a6
00012481dc07
------------------------
Thank

--
Message posted from http://www.ExcelForum.com