MS Excell VB macro
Budget: $30 – $250 USD
Need a macro written that looks for duplicate or overlaping
- IP addresses
- Phone numbers
Format of the phone numbers will be
- COL N will have the IP or phone number
- COL P will say "IPADDRESS" or "PHONE" to explaine the data in the cell
the macro needs to search the IP's and phone numbers looking for dulicate values and highlighting the two cells that are dulpicates in the same color. If more than one exists it will use a different color to indecate those cells.
IP address are formatted as follows
1) Single IP XXX.XXX.XXX.XXX (Single IP)
or
2) Subnet is XXX.XXX.XXX.XXX/XX (Cider notation)
Phones numbers are formatted as follows
1) XXXXXXXXXX (Single phone)
or
2) XXXXXXXXXX:XXXXXXXXXX (Range)
- IP addresses
- Phone numbers
Format of the phone numbers will be
- COL N will have the IP or phone number
- COL P will say "IPADDRESS" or "PHONE" to explaine the data in the cell
the macro needs to search the IP's and phone numbers looking for dulicate values and highlighting the two cells that are dulpicates in the same color. If more than one exists it will use a different color to indecate those cells.
IP address are formatted as follows
1) Single IP XXX.XXX.XXX.XXX (Single IP)
or
2) Subnet is XXX.XXX.XXX.XXX/XX (Cider notation)
Phones numbers are formatted as follows
1) XXXXXXXXXX (Single phone)
or
2) XXXXXXXXXX:XXXXXXXXXX (Range)