JP2R
04-17-2008, 05:31 PM
Background:
We work on a secure campus and have recently started to search for ad hoc networks (rogue? networks) on the campus.
I have created a spreadsheet that has:
Column A: MAC_Address
Column B: Name
Column C: Email
Column D: SSID
Column E: Host_Name
Column F: Email_Sent (Y/N)
Column G: Date_Sent
Column H: First_Time (Detected)
Column I: Second_Time
Column J: Third_Time
Column K: Resolved
1. MAC_Address is what I was originally thinking to be unique, however, I noticed that I could detect an ad hoc from a certain MAC Address with a particular SSID and send them and email and ask them to remove it, but they wouldn't check to see if they had any others 'up', so when I ran the search later I would find them again with a different SSID (I hope this makes sense).
So I was trying to look and check for duplicate MAC Addresses, and then if it was duplicated to insert a row, just below the first event/entry so that that MAC Address could be inserted with the new information...
I wasn't sure if this could be done with an in-cell function or VBA - I was trying to figure out how best to update the information, but I've been thinking about it so long I thought I had best ask you guys...
I can do all sorts of in-cell stuff, but am really weak on VBA...
I made a post earlier asking about how to get the data from the Cisco website into Excel so that I could update, but wasn't sure how to do this...
I have to automate as much as possible because I don't want to spend all my life on this project - if it can be automated - anyone can do it.
If you need a visual I can try and put something unclassified together...
I am using a Dell Laptop//Microsoft Office 2007 Prof//Browsers used IE and Firefox most current versions
-- Jae
We work on a secure campus and have recently started to search for ad hoc networks (rogue? networks) on the campus.
I have created a spreadsheet that has:
Column A: MAC_Address
Column B: Name
Column C: Email
Column D: SSID
Column E: Host_Name
Column F: Email_Sent (Y/N)
Column G: Date_Sent
Column H: First_Time (Detected)
Column I: Second_Time
Column J: Third_Time
Column K: Resolved
1. MAC_Address is what I was originally thinking to be unique, however, I noticed that I could detect an ad hoc from a certain MAC Address with a particular SSID and send them and email and ask them to remove it, but they wouldn't check to see if they had any others 'up', so when I ran the search later I would find them again with a different SSID (I hope this makes sense).
So I was trying to look and check for duplicate MAC Addresses, and then if it was duplicated to insert a row, just below the first event/entry so that that MAC Address could be inserted with the new information...
I wasn't sure if this could be done with an in-cell function or VBA - I was trying to figure out how best to update the information, but I've been thinking about it so long I thought I had best ask you guys...
I can do all sorts of in-cell stuff, but am really weak on VBA...
I made a post earlier asking about how to get the data from the Cisco website into Excel so that I could update, but wasn't sure how to do this...
I have to automate as much as possible because I don't want to spend all my life on this project - if it can be automated - anyone can do it.
If you need a visual I can try and put something unclassified together...
I am using a Dell Laptop//Microsoft Office 2007 Prof//Browsers used IE and Firefox most current versions
-- Jae