Search:

Type: Posts; User: ayazgreat

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Excel VBA Highlight Duplicates and Duplicate between Range

    I have posted subjected thread on below link but it seems to be just like a challenge work I just want to know that can it be possible through macro as I mentioned on given link.
    ...
  2. Alan Thanks so much explaining and guiding me.

    Alan Thanks so much explaining and guiding me.
  3. Alan, it is amazing, you really did a great job....

    Alan, it is amazing, you really did a great job.
    Thank you so much for working and time you spent for it I really appreciate this.
    However these code are taking a long time when I run this macro on...
  4. Is the answer:- that there is a break in days /...

    Is the answer:- that there is a break in days / missing days
    4-Jan-22 ……… 6-Jan-22
    7-Jan-22 …………………………… 2-Apr-22

    Is the criteria for different rows in the results 2 things:
    _a) Different Number...
  5. Please find attached required detail ...

    Please find attached required detail




    https://www.youtube.com/@alanelston2330/featured
  6. Alan, Please find attached updated file for...

    Alan,

    Please find attached updated file for your question that why I have more than 1 result for 12345.
    Actually if you see result sheet I am calculating total days and total working days between...
  7. My Actual required result in attached file in...

    My Actual required result in attached file in result sheet if anybody can solve it please through VBA code ?
  8. I am facing an issue of incorrect result and...

    I am facing an issue of incorrect result and furthermore if add following column in result sheet so how should power query be updated
  9. Thanks for your reply I just want to know that...

    Thanks for your reply I just want to know that where should I copy these power query code to run further I have 5 lacs rows of data so how much does it take time to complete ?
  10. Copy to Summarise data based on 2 criteria: User ID and gaps in continuous day segments for same user

    Hi Krish.
    I have posted subjected thread on below link and i request you please help me to resolve it
    ...
  11. yes patel I have provided sufficient explanation...

    yes patel I have provided sufficient explanation regarding to my problem , where is confusion ? furthermore I will update complete data workbook.
  12. Could anybody please help to resolve it ?

    Could anybody please help to resolve it ?
  13. Convert Series into Range with specified count

    Hi Kris
    How are you ? I need your help for following macro coded by you , actually this macro convert all different series into different range breakups and now I want to convert series into range...
  14. Replies
    6
    Views
    2,084

    Thanks Bakerman , it is working fine now

    Thanks Bakerman , it is working fine now
  15. Replies
    6
    Views
    2,084

    Thanks for your replay but following codes are...

    Thanks for your replay but following codes are giving compile and syntax error


    Private Sub cmdShowData_Click()

    Dim rngTarget As Range, i As Integer
    Application.ScreenUpdating = False...
  16. Replies
    6
    Views
    2,084

    Thanks bakerman for your reply but you have...

    Thanks bakerman for your reply but you have converted only one macro of attached workbook there are more macros/code in attached workbook


    Private Sub cmdReset_Click()
    'clear the data
    ...
  17. Replies
    6
    Views
    2,084

    Covert SQL Code to VBA

    Hi All

    I have downloaded attached workbook from a web side and the code used in this work is in SQL , which are difficult for me to understand I want to know that if attached workbook code can be...
  18. Replies
    35
    Views
    6,015

    Wooo, it is amazing you did it what I required,...

    Wooo, it is amazing you did it what I required, by modifying my provided code, i am very glad , thank you very much Charles, i really appreciate your efforts and time invested by you to resolve it.
  19. Replies
    35
    Views
    6,015

    Charles how should I change location that helps...

    Charles how should I change location that helps you modify code where do you want to keep location grid
  20. Replies
    35
    Views
    6,015

    kinldy help to resolve it

    kinldy help to resolve it
  21. Replies
    35
    Views
    6,015

    Is there any progress ? Could someone else solve...

    Is there any progress ? Could someone else solve it please ?
  22. Thank you very much both of you, it works fine ...

    Thank you very much both of you, it works fine



    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
  23. Converge Data From Multiple Columns To Single Column

    hi

    I want to copy data (from col a to onwards) from sheet1 to sheet2 (converting in only 3 cols) ignoring cells having blank or 0 value. I am attachig here an example workbook.

    Thanks in...
  24. Thread: Delete Rows

    by ayazgreat
    Replies
    2
    Views
    1,283

    Thank you very much Sir, it works fine.

    Thank you very much Sir, it works fine.
  25. Replies
    1
    Views
    5,515

    Thanks Admin, it is great and it works wonderful,...

    Thanks Admin, it is great and it works wonderful, really you are doing great job.

    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    ...
Results 1 to 25 of 86
Page 1 of 4 1 2 3 4