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.
...
Type: Posts; User: ayazgreat
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.
...
Alan Thanks so much explaining and guiding me.
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...
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...
Please find attached required detail
https://www.youtube.com/@alanelston2330/featured
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...
My Actual required result in attached file in result sheet if anybody can solve it please through VBA code ?
I am facing an issue of incorrect result and furthermore if add following column in result sheet so how should power query be updated
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 ?
Hi Krish.
I have posted subjected thread on below link and i request you please help me to resolve it
...
yes patel I have provided sufficient explanation regarding to my problem , where is confusion ? furthermore I will update complete data workbook.
Could anybody please help to resolve it ?
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...
Thanks Bakerman , it is working fine now
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...
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
...
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...
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.
Charles how should I change location that helps you modify code where do you want to keep location grid
kinldy help to resolve it
Is there any progress ? Could someone else solve it please ?
Thank you very much both of you, it works fine
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
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...
Thank you very much Sir, it works fine.
Thanks Admin, it is great and it works wonderful, really you are doing great job.
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
...