View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Natla22@yahoo.com is offline
external usenet poster
 
Posts: 1
Default Macro to match output from 2 columns...

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