Sharing pricture of excel table on how I imagine it should look.
I tried to use Random AHK function to control ranges of dates, but code is very slow and it will take me to generate in excel all data ~120 hours.
What is why I was looking for help (do it with AHK or maybe there is some data generators tools).
It does not matter where I generate that data, because I will copy it to excel. Speed is important, but I can wait and 10 min if needed. If data values are valid, that is perfect, if it is not, I will survive.
In my example I was trying to control date validation ranges with AHK Random function for each year, month, day, hours, min, sec and add 0 if needed if date would have 1 digit (not 1.1.2022 1:1:15 but 01.01.2022 01.01.15). My knowledge with dates and formatting dates are weak, that is why I mentioned that dates does not valid for leap years, because I do not know how to control it. I might misguided you guys with my request when mentioned that it is dummy data and you focused on speed. I am sorry for that.
@flyingDman your example is what I needed and I explained why I chose your example. You understood me right.
I red all comments and it is great when many AHK, Excel and other experts take a look at the task with different approach.
Speed, data validation, possibility to control ranges is important and would be great. Your example was what I needed for my knowledge - you speed up all code, plus - all ranges I can control and for me it is enough.
If it is possible to generate data fast with leap year (valid data) and right format that would be great. But you did what i asked
I really appreciate all experts on this topic and please except my apologize if I misguided you.
flyingDman wrote: ↑24 Jan 2022, 18:33@DanRim Could you provide an example of what the final output should look like in Excel?