How to create macro for extracting data sample range

Occasional Contributor

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


2 Replies

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.

Hello thanks for your help, appreciate.

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





Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
50 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
32 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
15 Replies
Dev channel update to 80.0.355.1 is live
josh_bodner in Discussions on
67 Replies