• 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. A

    Copy paste data into new workbook

    Output file i attached
  2. A

    Copy paste data into new workbook

    Hi, I have data in workbook with 4 worksheets i want to copy those data into new workbook with 2 worksheets( SF & EE) only this workbook save in desktop with current month name & year. can some one help how to create vba code for this
  3. A

    How to run two Loops with Counditions

    Hi Now I have mention expected result as well in this file. Where is Add details mention in Column E then check range if any non blank cell if found any value then check above cell if any data or not if data found then this consider as in correct format & Below cell data is any value found...
  4. A

    How to run two Loops with Counditions

    Hi I have multiple file in one folder all files format is fix like sheet names and Template format. I want to check Sheet 1 Data IF Add details word match in range E14:E100 this case is match. Then Check Same Row from Column F to AJ Non Blank Cell If find non Blank cell then is any value in...
  5. A

    From Web page how to select check boxes

    We tried with this on our macro but it is not work so please give idea for this Set ieDoc = IE.Document Set ieCom = IE.Document.all kRow = 0 kCol = 1 For k = 1 To ieDoc.all.Length - 1 If TypeName(ieDoc.all(k)) = "HTMLTable" Then...
  6. A

    From Web page how to select check boxes

    Hi If Comments is NO on web page then corresponding checkbox will be clicked or selected. For Yes comments checkbox won’t be clicked. After Selecting all the checkbox with “No” comments on webpage, Delete button will be clicked I want this through be done via Excel VBA please help on this...
  7. A

    Match Multiple Criteria

    Good one i also tried same thing
  8. A

    Match Multiple Criteria

    Hi I tried with this its work but apart from any method & how to highlight more than 1 same criteria Please tell me =IF(SUMIFS($D$3:$D$14,$B$3:$B$14,$G10,$C$3:$C$14,H$2)=0,"",SUMIFS($D$3:$D$14,$B$3:$B$14,$G10,$C$3:$C$14,H$2))
  9. A

    Match Multiple Criteria

    Hi I have data in that match multiple criteria i.e Assignment & Element if both match then give Units i have tried with vlookup but if more than 1 same value then this will not work in that case i want to highlight that Assignment number & add up that Units please tell me how to do this
  10. A

    Data in excel change proper format

    This one formula i tried but in this how to minus 2 from last 3 numbers can you please tell me =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,".",""),"(","_"),"^","_"),"+"," ")
  11. A

    Data in excel change proper format

    now i am using formula to do this but its take time so i ask for macro
  12. A

    Data in excel change proper format

    i do not have code with me now so i can not share that and my question is when 3.58E+156 this type of value how to convert like after + sign number 156 minus 2 then 154 comes then original value 358E154
  13. A

    Data in excel change proper format

    Ok that macro part i will check but if any method like this to replace "." then "+" and after + sign number -2 from that value means from this value 3.58E+156 358E154 my original value come Please tell me how to do this Sub ChgInfo() Dim WS As Worksheet Dim Search...
  14. A

    Data in excel change proper format

    Macro part from MS access data base this macro pull data from table so i am not aware where i need to change in code because in that macro SQL method is also use so i am not sure
  15. A

    Data in excel change proper format

    If Use Z358E154. then same value show how to replace that to 358E154 if text format cell replace the Z then gives 3.58E+156 value
  16. A

    Data in excel change proper format

    i tried with this method format text but when macro copy paste data then this values are converted so please tell me how to this type value converted into original value
  17. A

    Data in excel change proper format

    Hi I have data in excel when 358E154 this data enter into cell then this convert like this 3.58E+156 can any one tell how to avoid this or if this type of value how to convert again into like this 358E154 please tell me
  18. A

    Unable to solve this question

    No Veltm say vlookup work in my file so i ask where show me then he post then i ask upload with my file data then no one upload that but telling no vlookup is work then u told me lookup table is not sorted then i both of pic then u told me no we are saying u need to sort the data where i post...
  19. A

    Unable to solve this question

    This both Image lookup table is sorted so if you are telling no need to sort data then please upload in my file the vlookup formula
  20. A

    Unable to solve this question

    what showed in #7 post that array table is sorted please look my file in that array table is not sorted
  21. A

    Unable to solve this question

    Ok when you are telling me vlookup work without sorting array table then please upload file with formula so i know what is wrong when i used vlookup This Formula work in this type =INDEX(Reference!C$2:C$11,MATCH(H2,Reference!B$2:B$11,-1)) Please upload file with vlookup without sort array table
  22. A

    Unable to solve this question

    i know that when i ask u in vlookup data need to sort or not u told no need u give example for exact match where i ask approx match
  23. A

    Unable to solve this question

    what u show me in the pic exact match case then vlookup work but my case is not this
  24. A

    Unable to solve this question

    vletm i ask where lookup array table not sorted then apporox match not work
  25. A

    Unable to solve this question

    Yes means i am correct with out sorted data vlookup not work in approximate match case
Back
Top