• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. I

    Extract ip address row from a ip range and subnet mask

    Report @rlv01... Thanks for assisting. Have uploaded both Before and After files. Have added sample 5 rows data in column A. Have approx. 4000 rows of ip address in my original file.
  2. I

    Extract ip address row from a ip range and subnet mask

    Thanks. Works only for first row in sheet1,Doesn't check on other rows in sheet1
  3. I

    Extract ip address row from a ip range and subnet mask

    I found this online and tweaked a bit,,Getting run time error 13 and stops at 'ipArray = Split(ip, ".") ' >>> use code - tags <<< Sub CheckIPAddress2() Dim ws1 As Worksheet, ws2 As Worksheet Dim ip As String, startIP As String, subnetMask As String Dim ipRange As Range, cell As...
  4. I

    Extract ip address row from a ip range and subnet mask

    Hello .. I am trying to find a vba script for column A in sheet1 that will check an IP address in sheet2 column C (start of IP address) and column F (Subnetmask) and find if it falls into a range (or between). If IP available in range, I want to copy complete row into sheet1 column B. If IP not...
  5. I

    Data cleanup from row to column

    Thank you @p45cal ...Macro works as expected.
  6. I

    Data cleanup from row to column

    Thanks P45cal....Was looking for a vba macro to connect with other code
  7. I

    Data cleanup from row to column

    Hi Need assistance with copied router data into excel for cleanup. Data is more than 1000 rows a. Convert row data to separate columns b. Delete row\data with certain text "Network Next Hop Metric LocPrf Weight Path" c. Have highlighted scouple examples - delete row\text...
  8. I

    Ip address match and extract from subnet range

    Hello Need help with a macro to extract ip address from sheet2,sheet3... matching with the range in subnets in sheet1. In this sample file attached, have 2 sheets(sheet1,sheet2) Sheet1 has ip address with subnet (/xx) Sheet2 has ip address and other data In some cases, i have ip address in...
  9. I

    Index and Match for wrapped number

    When formula dragged down n across , if takes previous entries even thou column A(input sheet) is blank and it doesn't do the exact match. Attached test file with formula provided
  10. I

    Index and Match for wrapped number

    Hello, Having issues with index and Match for wrapped number in cell. Using below formula and works fine for single ip in both input sheet and Data sheet. =IF(ISNA(INDEX(Data!$B$2:$B$10,MATCH(input!$A2,Data!$A$2:$A$10,0))),"",INDEX(Data!$B$2:$B$10,MATCH(input!$A2,Data!$A$2:$A$10,0))) If...
  11. I

    Excel formula

    thanks
  12. I

    Excel formula

    Hello, Need assistance with formula When formula typed into cell =(O8-M8)/O8 gives =DIV/0! error when empty. Require cell to be blank. Thanks
  13. I

    vlookup for wrapped text contents in cell

    @Nebu .. Require exact match to be extracted instead of closest match
  14. I

    vlookup for wrapped text contents in cell

    Awesome..Thanks So much..
  15. I

    vlookup for wrapped text contents in cell

    Hello , Looking for assistance to extract row from matched data from sheet 2 Issue is - unable to lookup data if entry is wrap text or used ALT /ENTERin sheet 2 Using below formula =VLOOKUP($A2,Sheet2!$A1:$H8,3,FALSE) Attached sample file Thank you
  16. I

    Match and extract column info from 2 workbooks

    Hi I have 2 workbooks ... Master.xls (Sheet "Test1") and Info.xls (Sheet "Test2") Macro reqd. to match "Column B" in Master.xls (Sheet "Test1") with "Column B" Info.xls (Sheet "Test2") if matched found between 2 workbooks Then copy "Column E" Info.xls (Sheet "Test2") INTO blanks "Column H"...
  17. I

    extract matched data from multiple sheets

    @vletm Thanks for taking a look.. 1. column A sheet1 has mix of numbers and text (in this case ip address and fruit names) and some of fruit names are in lowercase and uppercase. This data in column A needs to be matched with other sheets (except for "output" and "outputexample" sheets) and...
  18. I

    extract matched data from multiple sheets

    @vletm Thanks for assisting. Have additional requirement for the code previously provided If duplicate item is present in column A (Sheet1) , It doesn't extract the info. and case sensitive items aren't extracted In output tab - Have to copy in same order as sheet1 (See output reqd in...
  19. I

    Macro extract data from multiple sheets based on matched criteria

    @jindon Hi Columns have been changed and added new columns from previous ask. Have made few changes and was able to fix few requirements Require assistance with below 1. New column "Variance" is reqd. in Output sheet after "breakdown" column for each vendor. 2.Have created dropdown list in...
  20. I

    extract matched data from multiple sheets

    @vletm Thank you so much..It works
  21. I

    extract matched data from multiple sheets

    @vletm Can hyperlink be inserted for matched data in Sheet1? It would make it easier to look for the data in sheets as mentioned in first post have 25 sheets and around 2000 rows of data in each sheet. Private Sub Get_Rows() Application.ScreenUpdating = False On Error Resume Next...
  22. I

    extract matched data from multiple sheets

    Thanks vletm... If an easy tweek to code ,Can the matched rows be copied and pasted into new sheet called"output". If not,Code provided does the work. Thanks again
  23. I

    extract matched data from multiple sheets

    Attached sample test file.. Appologize ..Thought had attached in my first post
  24. I

    extract matched data from multiple sheets

    Hello, I have ip address in column A sheet1 , Need to extract matched ip address row from multiple sheets(Around 25 sheets) in workbook and paste in new sheet,Would be nice if sheet name is also included for matched ipaddress. Note : - Have ip address in different columns in each sheet - Have...
  25. I

    Macro extract data from multiple sheets based on matched criteria

    @jindon Any suggestions on above
Back
Top