ip address

  1. K

    Macro to vlookup multiple columns

    Hi, I need to populate almost 10 columns with information from another excel sheet. We usually do it using vlookup. Can we use a macro and automate it. SO that I just click once and all the columns gets populates. Table A where the information needs to be populated <tbody> IP Location Metal...
  2. S

    retrieve Hostname from IP address using VBA

    Hi a Colleague wrote the below and has now left the company, I now need to expand the code so in cell.offset (0, 4) it will display the FQDN, is this possible? The IPs start at Cell 'A2' and generally go down to row 254 Thanks in advance Stuart :confused: Sub PingTest() Dim Cell As...
  3. J

    Conditional Concatenation of Multiple IP Address Values Into One Cell

    I have the ff. tables in a worksheet: Table A (Sheet 1) - a list of 1000+ computers that don't have a specific piece of software installed Table B (Sheet 2) - a list of 15000+ host-to-IP address entries from the local DNS obtained using the <code style="margin: 0px; padding: 1px 5px; border...
  4. B

    Replace text after nth occurance of character?

    I have a list of IP addresses: 10.9.8.14 10.9.8.24 10.9.8.17 10.9.8.56 10.115.4.3 10.115.4.16 10.115.4.88 10.24.2.132 10.24.2.55 I am looking for a formula to take this column and generate the following in the next column: 10.9.8.0 10.9.8.0 10.9.8.0 10.9.8.0 10.115.4.0 10.115.4.0 10.115.4.0...
  5. D

    Excel Lookup IP addresses in multiple ranges

    I am trying to find a formula for column A that will check an IP address in column B and find if if falls into a range (or between) 2 addresses in in two other columns. C and D. E.G. <tbody> Valid? address range start end yes 10.1.1.5 10.1.1.0 10.1.1.31 yes 10.1.3.13 10.1.2.16 10.1.2.31...
  6. F

    excel macro code for vp and ip address

    Hi, I'd like to know if there's a simple code for getting the vpn and ip address of a computer. Thanks. I already have the code for the username - I'm missing getting vpn and ip address or where the computer connects to the internet.
  7. N

    Determine if IP is in Subnet + Lookup

    Hi guys - I have am trying to take a list of 250k IP Addresses and determine if they are in subnets that are part of my organization. I would prefer to do this with just formulas but am open to VBA as well...i just dont understand it as well. The first two columns I have, the third is my...
  8. J

    Update Connection String's IP address with cell content change

    I've got a spreadsheet consisting of several ODBC queries that I need to distribute to multiple individuals. The ODBC server's IP address in the Connection String will be different for each individual so I'm looking for a way to update the server's IP address based off of an IP address I enter...
  9. F

    Vlookup IP Subnets

    Hello first time poster here, I'll try to be as clear as I can :) I am currently being slowly driven to the brink of madness trying to work out why a vlookup is always returning #NA. The goal is for every IP address listed in a table I need to automatically work out the location based on the...
  10. B

    IP Address Range Calculator

    Im sure this has been posted but after reading over this forum and others i still cannot find a solution. Given the first two columns of IP addresses i want to generate the third or even fourth Column <tbody> StartIP EndIP Total IPs Total /24s 1.32.0.0 1.32.127.255 32,766 128 2.15.0.0...
  11. S

    Extract Numbers from an IP address

    Hi I'm struggling to extract the last 1,2 or 3 digits from an IP address. the problem I have is that I have different length of IP address, so for example 10.1.93.145 145.10.5.16 145.168.192.1 I am trying to extract the numbers after the last full stop so the above example results would be...
  12. D

    Country Lookup by IP Address Range

    Guidance please .. I have two worksheets in my excel file. Sheet 1 - a list of IP addresses in column E ex: '1.123.57.208' Sheet 2 - a list of IP address ranges (roughly 11k rows) assigned to a particular country in columns A, B & C respectfully ex: '16.777.216' | '17.367.039' | 'AUSTRALIA'...
  13. F

    Connect to ip:port from a mac

    I need to connect to windows program another computer. The program has a winsock protocol running. I can telnet from the terminal of my mac and send and receive data. I would like to be able to do this inside excel with vba. I can imagine a separate program (ruby or something) that will do...
  14. M

    Vlookup IP Address in a Range

    Hello and thank you for your time. I am attempting to categorize IP Addresses. My lookup table looks like this: Begin End Category 1.50.50.0 1.50.50.255 3 5.185.40.0 5.185.43.0 2 5.22.22.65 5.22.22.128...
  15. T

    Show IP addresses with leading zeros

    Does anyone know how I can format a cell to always add zeros to IP addresses? ex. change 69.21.13.222 to 069.021.013.222 The cells data is being populated from other spreadsheets using a VLOOKUP. I just need the leading zeros. Thanks
  16. S

    VBA: Parsing multiple IP addresses from a string

    I have some code that will parse the FIRST IP address it finds in a string. Could someone help with the code for continuing through the remaining part of the string and parsing out any additional IP addresses it finds and concatenating them with a comma and space (", ")? There are specific...

Some videos you may like

This Week's Hot Topics

Top