Selected time copying

[thong127]

Hello Gurus,

I need your help again,

On my Attached File, I have a Data Sheet and I want only to copy the value of the Humidity & Temperature base on the value of time ending in :02 Like ( 9/13/2018 12:02:00 AM ; 9/13/2018 1:02:00 AM ; 9/13/2018 2:02:00 AM....) on the other sheet from September 13 up to Sept 20.

The format will be like in the "Format Sheet" of the attached file.

cross posted: https://www.excelguru.ca/forums/show...d-time-copying

Thank you

[modytrane]

see attached file [sheet1]

Here's the formula used in A2 and then dragged across to column E and down to row 250.

Hope this helps.

[thong127]

Hi Modytrane,

Thank you for the code. I really appreciate it.

[Kenneth Hobson]

Please Login or Register  to view this content.

[José Augusto]

Hi @thong127

With this data, you can use a much simpler formula

Try this and copy forward and down

Please Login or Register  to view this content.

[thong127]

Thank you All.