Forum Discussion
Assigning Source IP to Client excel function
NikolinoDE The Ip address and devices are not individually entered from the start in a table/chart format. Is there a way around this? If you see the attached file, you'll find there are 20,000 lines of data, and let's say for example 10% of the lines are individual IP addresses (repeated), so around 2000 unique addresses. Creating a table with 2000 IP addresses and device names will be time-consuming.
I am going to try to convert the data into a table format, sort the ip address and then assign a device to the ip addresses. Let me know what you think?
Send you this attached file with some examples.
I found it by chance on the Internet, which I can offer you as a suggested solution.
It seems that there are two possible solutions, but the VBA solution is only to check whether the IP is active or not or IP pinging.
The possible solutions are in the three Excel sheets.
If none of the proposed solutions are suitable for you, please inform us to find another approach (whatever).
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)