• 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

    SUM by colour is not giving correct results

    Yes, Thanks. Well Noted.
  2. A

    SUM by colour is not giving correct results

    Yes, The new code is working on all the sheets. Thanks a lot for your support
  3. A

    SUM by colour is not giving correct results

    Working Great Liked it
  4. A

    SUM by colour is not giving correct results

    Okay I will check the cells property first.
  5. A

    SUM by colour is not giving correct results

    Dear Marc L I am using Mac Excel where I don't have search and replace by format.
  6. A

    SUM by colour is not giving correct results

    Thanks for your message It is working in that sheet perfectly, But when I transfer to my original datasheet then it is not showing proper results as there is many different colours and structure of data. Can you please suggest some other code or excel formula to get the results.
  7. A

    SUM by colour is not giving correct results

    Can you please suggest what should change to get the correct results?
  8. A

    SUM by colour is not giving correct results

    Thanks, Marc L I just changed long to double and now it is working.
  9. A

    SUM by colour is not giving correct results

    Hi In the attached sheet sum by colour is not working or not giving proper results by using the below VBA Code Example in cells BS6 and BR33 sum value should be 100 but there is 99 Likewise many cells different values are there. Can anyone check and correct the code or guide me on what's the...
  10. A

    Repeat Row until Condition is met, Them move to Next Row and Reapeat

    You are Welcome!
  11. A

    [REQ] calculate the word before and after a designed one found in a cell

    Check the below image results and attached file.
  12. A

    Repeat Row until Condition is met, Them move to Next Row and Reapeat

    Check the attached file which is filling all.
  13. A

    Repeat Row until Condition is met, Them move to Next Row and Reapeat

    I assume that Day Partial start time and end time are fixed. I split the start and end time Download the file and select the client name then press [ Fill The "N" ] It will fill the "N" Column until Zero. Let me know the results are correct by checking with many clients Select one client...
  14. A

    Help with averaging in pivot

    Is the below image results are okay? check the attached file.
  15. A

    VBA date format not working

    Okay, Boss, I will fix the rows instead of the whole Column It is been exported from the tally. by default, it gives Kgs, Ltrs and Nos in all values.
  16. A

    VBA date format not working

    Boss, Manually press Ctrrl+F and replace is working in seconds. When I added in the code Kgs = "" Ltrs = "" Nos = "" Blanks = "0" Then For Loop it is taking couple of minutes.
  17. A

    VBA date format not working

    Hi Some part of the below code I created by macro recording and it is taking a couple of minutes to run the code. Is there any alternative way to reduce the time. Expecting your valuable reply. Option Explicit Sub Simple_For() Dim Startrow As Byte Dim LastRow As Long Dim i As...
  18. A

    VBA date format not working

    Dear Vletm I changed the code for copy-paste as below. now it is working fine. Range("A" & i).Offset(-1, 0).Copy Range("A" & i) Thanks for your support.
  19. A

    VBA date format not working

    Dear Vletm Thanks for your valuable reply. After steps 1 & 2 it has changed 02-Jan-2020 where our expected result is 01-Feb-2020, because of it's format 2/1/2020 The original exported file has 01-02-2020 in A8 after running the code it becomes 01-Feb-2020 After that, I just used offset and...
  20. A

    VBA date format not working

    As per below image, After running the code some of the cells date not formating as defined. How do I change the code to get "dd-mmm-yyyy" formats
  21. A

    VBA - Find the filter date for the subject line in email.

    Well Noted. Thanks!
  22. A

    VBA - Find the filter date for the subject line in email.

    Without those formulas, it is working fine. See the below screenshot. I used that formula in A8 for my other requirements https://www.dropbox.com/s/vro068mimp0cp1x/LOG%20BOOK%202020.xlsm?dl=0
  23. A

    VBA - Find the filter date for the subject line in email.

    Sure, I will take care.
  24. A

    VBA - Find the filter date for the subject line in email.

    It is working perfectly. Thanks a lot for your support.
  25. A

    VBA - Find the filter date for the subject line in email.

    I am selecting like below screenshot. A1: J23
Back
Top