Data update 9.2015

[tax112]

Hi everybody!
I have one table of data from A4: M800, starting from the first day to the last day.
The value measured 24 hours / day and 12 times / hour, 5 minutes jump from 0 minutes to 55 minutes.

Can someone help me 1 VBA code to transfer the data to a spreadsheet on the right front (few figures illustrate 1)
I thank you in advance

[jindon]

Try

Please Login or Register  to view this content.

[tax112]

Try

Please Login or Register  to view this content.

Very exactly
That's what I want. Thank you very much.

[Richard Buttrey]

Hi,

A macro isn't actually necessary. The following in R6

Please Login or Register  to view this content.

and in S6

Please Login or Register  to view this content.

both copied down will give you the results. Of course if it must be a macro I'd still be inclined to use a macro to write those formulae into the R:S cells for you.

[tax112]

Hi,

A macro isn't actually necessary. The following in R6

Please Login or Register  to view this content.

and in S6

Please Login or Register  to view this content.

both copied down will give you the results. Of course if it must be a macro I'd still be inclined to use a macro to write those formulae into the R:S cells for you.

I am glad you are interested in my topic.
I added 1 way anymore. Thank you very much