I have two columns of data that I need parse data from every 1 second to every 10 minutes.

Hi everyone,

I need a macro to parse a big data set. The data is logging every second, however I only require the values when it starts, then every 10 minutes after that. I process this file after its collected.

I want to start at the first time in R2C1, copy both the time and the Baro value. So copy R2C1 & R2C2 (both cells) for that time. Then paste these values into another worksheet. Then I need the next value 10 minutes later & repeat it for the entire file. So one continuous loop until all values are pasted into the one worksheet.

Time.........Baro
23:14:13 1022.7
23:14:14 1022.71
23:14:15 1022.67
23:14:16 1022.65
23:14:17 1022.63
23:14:18 1022.63
23:14:19 1022.64
23:14:20 1022.67
23:14:21 1022.69
23:14:22 1022.7
23:14:23 1022.66
23:14:24 1022.66
23:14:25 1022.65
23:14:26 1022.64
23:14:27 1022.65
23:14:28 1022.67
23:14:29 1022.71
23:14:30 1022.72
23:14:31 1022.7
23:14:32 1022.65
............ ...........
23:24:14 1022.60
............ ...........

Heres the code and the attachment I have so far. A loop may be easier.

The macro I recorded copied the first set of values and pasted it into a new sheet, then I added 10 minutes to the initial value in the cell below. Then I copied that new value and searched for it, then copied the correct set. I basically need a loop. This method I am using is not efficient.

Please Login or Register  to view this content.

Barometer Readings 2.xlsm

Put this formula in C2, drag to D2, and drag down

Formula:

Please Login or Register  to view this content.

Hello reesjordan,

The macro below has been added to the attached workbook and tested with the data.

Please Login or Register  to view this content.

if you need a code that can trigger a another code based on time, try this:

Please Login or Register  to view this content.

that above runs in 10 seconds from whatever time it is now - it runs the YourOtherSub

you can change the timevalue to any amount of time you need the code to automatically initiate
thus this would run in 1 hour

Please Login or Register  to view this content.

so... to make it a loop running by itself automatically...

Please Login or Register  to view this content.

this code runs the My_other_Sub in every 10 seconds. Notice it has "Call Example" on the end of the My_other_Sub - that part makes the code repeat..


hope this helps..

Hello reesjordan,


Thanks for the feedback and marking your post as solved.