I have a great little macro written by EE that helps me declare a frequency of sensor data based on a specific time horizon. The frequency is based on a unit of time. What I need is a macro that reads the frequency and creates both a date entry and a random sensor reading for as many frequency events as declared. The formula for the sensor reading is generated using "randbetween" formula with a declared Min. / Max.
Thank you in advance.