• 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

    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...
  2. 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...
  3. 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...
  4. 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...
  5. 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
  6. 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
  7. 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"...
  8. 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...
  9. I

    Modify vba code

    Hi, Require assistance to modify code below As data is entered in column J6 : J19 cells , each cell in Column K to divide J6 :J19 by " J20" Example : J20 has data= 120 user inputs in J6 as 10 Column K6 result = J6/J20 user inputs in J7 as 20 Column K7 result = J7/J20 and so on... Much...
  10. I

    Formula for weekdays

    Hi , Any help ? Looking for formula to extract ONLY Off hours between 2 given dates and times Off hours Weekdays Mon 5pm to next day 9am Off hours Weekend (Friday- 5pm to 9am Monday) format of dates: m/d/yyyy h:mm See attached file for ref.
  11. I

    Fill data based on drop down month

    Hi Have a drop down for month in J5 cell and data is entered based on month in below cells J6:J21 and data calculated in col K using formula. Require column K data copied over to month (Col L for Jan) and if another month selected in col J5 must add data accordingly to other months columns...
  12. I

    Macro extract data from multiple sheets based on matched criteria

    Hello, Need assistance with macro to extract data from multiple sheets based on matched criteria and sum up the values. All vendor data must start from col (C), Below query copies data to other column if no match in first or second sheet. Hope was able to put my question thru properly...
  13. I

    Add save edit delete data in column from dropdown list

    Hi, Macro needed : Have dropdown list with months in(Col B3). Is it possible to save data in other cells(column B4:B15) using dropdown (B3) and retrieved. If any change made in B4 :B15 -data to be saved for the chosen month(B3) Thanks
  14. I

    Formula for data extraction from multiple sheets based on condition

    Hi, Need help to extract data from multiple sheet using formula and total the numbers. Have attached sample test file for ref. Thanks ..
  15. I

    excel formula to subtract text format date\time

    Hi, Require excel formula to subtract date\time(In text format column B and C) and give results in Column D (output column) Using =($C4-$B4)*1440 in output column gives #VALUE date format : ddd mmm dd, yyyy - hh:mm AM/PM Date 1 Date 2 Output Sun Jan 11, 2017 - 09:00 AM Sun Jan 11, 2017 -...
  16. I

    Automatic update current date and time in same row based on specific text input

    Hi, If User types in "Yes" anywhere in Column ranging from G3 : G40 , Is there a macro that it would automatically update\write the current date and time in Column L There is already a date and time in col L for assigned task. (Date format in col L is "ddd mmm dd, yyyy - hh:mm AM/PM") Any...
  17. I

    Match color in Columns

    Hello, Using below Macro to highlight duplicate date\time in column D- Works fine. Challenge i have is to find matching date\time in other column E and highlight with same color as column D. Kindly Assist ...Thank You Sub test3() ' Highlight dup times in col D Dim r As Range, myColor, n As...
  18. I

    Extract selected data from another sheet

    Hello, Require assistance in creating macro to extract data based on matched criteria in Column "E" Number header in "Output" sheet and column A in master sheet "DATA" Columns details that needs to be extracted in "Output" sheet that matches Col A in Sheet "Data" are (Status , START DATE...
  19. I

    Formula between 2 dates and times

    I Need to calculate total hours and minutes between 2 dates in column Cand D and output in E Format of dates in Column C and D : ddd mmm dd, yyyy - hh:mm AM/PM Format of Column E : hh:mm D14 : Sat Dec 02, 2016 - 12:30 PM C14 : Thu Dec 01, 2016 - 09:00 AM Output in Cloumn E14 : hh:mm Help...
  20. I

    Find and replace

    Hi, Looking for a macro to find and replace in specific sheet (Data) and in specific column (A) for mutilple entries and replace in excel 2010. have around 1000 entries and list grows every month. Help will be really appreciated... example : Find :John Doe replace: John chang Find :karla jin...
  21. I

    Macro to save data from dropdown

    Hi , Looking for macro for below queries 1. To hide rows in all named sheets ( jan ,feb,...dec,Total) with pop up user input message : Which row to hide? 2. To unhide all rows in all named sheets 3.To insert ROW in all named sheets with above formulas and formatting with pop up user input...
  22. I

    Extract data from other sheet

    Require assistance to extract info based on Master sheet column A10 (Year dropdown) and Column B10 ( Employee name dropdown) from "DATA" sheet starting from row27 output needed is the total in C10 ,D10 ,E10, F10 ,G10 , H10 from "DATA" sheet. Help will be appreciated ...
  23. I

    Macro to Dial out from PC using voip cisco ip phone

    Hello, Working on spreadsheet to dial out number using a macro, So far have been able to bring the dialer up and prompt to enter number. Need help to complete the code , see attached file Basically, Require to dial number out by pressing macro button from spreadsheet. Manual dialout method is...
  24. I

    Add Numbers with text in row

    Hello, Need assistance in adding numbers with text in a row ,Total needs to be updated dynamically as numbers change in row. Have drop downs in cells to select V 1.0 or S 1.0,S 0.25, S 0.5 list ex : Row 4 : V 1.0 v 0.25 D 0.25 D 1.0 output reqd. Row 5 under P column 1.25 under S...
  25. I

    Transpose or macro to convert multiple rows to Column

    Hi Everyone, I' ve been searching threads to convert multiple rows with same items to single column Header and get subsequent data related to items.Have huge data in multiple rows and column, Kindly provide a solution to convert multiple same data rows into columns as below. Have attached...
Back
Top