Natla,

It would be best if you posted examples of your data, and how the extract
would look based on that data.

HTH,
Bernie
MS Excel MVP

" wrote in message
...
We have 1500 clients plugged into 50 switches throught our
BAN. I have done an nbtstat -a on all 25 of our networks
and put the results into column B.
Column A has the results from a 'sh cam dynamic' on all 50
switches.
I need a macro to search thru column B and column A to put
the results in Column C-F. Basically I need to know the
what workstation,username,mac, and vlan that is plugged
into my switch ports.

Thanks for your help....

Natla