Forum Discussion

serge625's avatar
serge625
Copper Contributor
Feb 22, 2019

How to create macro for extracting data sample range

Dear all,

I have a sample excell Sheet 1 in wich I have a bunch of data collected by an aquisition system. The date a represented as :

In A column: date and time of the sample
In B column value of the sample

 

I have 1000 records displays. The goal is that within this 1000 records, I need to display in Sheet 2 :

- Column  A the date and time  of sample at T0+60second of Shhet 1

- Column  B the Value  of sample at T0+60second of Shhet 1

 

In other words from the whole set of the 1000 records wich I have collected I need to extract one record every 60s

 

How cqn I do that with a macor, never doen this before and never use but if you provide sample I could understand

 

Thanks for help

regards 

excel
Macros and VBA

2 Replies

  • Rich99's avatar
    Rich99
    Iron Contributor
    Feb 26, 2019

    Serge, Can you post some sample data? I made a start and have attached a spreadsheet which still needs a lot of work for it to run seamlessly. Before going further I want to sure its what you're looking for.

    • serge625's avatar
      serge625
      Copper Contributor
      Feb 26, 2019

      Hello thanks for your help, appreciate.

      see this thread I have post on VBA forum in case :

      https://social.msdn.microsoft.com/Forums/vstudio/en-US/27201fa3-0fb1-49dc-8e9b-277d18089304/how-to-get-value-of-column-measure-for-each-30s-time-interval-of-column-a?forum=isvvba

       

      regards

       

Resources