malaypatel
New Member
- Joined
- Aug 30, 2014
- Messages
- 1
here under is my excel sheet it gets every 5 minutes data.
but i want to paste every 15 minutes data on G H I J K L column respectively.
suppose at now time 9.00 AM when time 9.15 AM that data automatically paste on another mention column G H I J K L respectively .
is it possible ?
<tbody>
[TD="class: xl65"]A
[/TD]
[TD="class: xl65, align: right"]B
[/TD]
[TD="class: xl65, width: 64, align: right"]C
[/TD]
[TD="class: xl65, width: 64, align: right"]D
[/TD]
[TD="class: xl65, width: 64, align: right"]E
[/TD]
[TD="class: xl65, width: 64, align: right"]F
[/TD]
[TD="class: xl65, width: 64, align: right"]G
[/TD]
[TD="class: xl65, width: 64, align: right"]H
[/TD]
[TD="class: xl65, width: 64, align: right"]I
[/TD]
[TD="class: xl65, width: 64, align: right"]J
[/TD]
[TD="class: xl65, width: 64, align: right"]K
[/TD]
[TD="class: xl65, width: 64, align: right"]L
[/TD]
[TD="class: xl65"]31.07.2014 09:20
[/TD]
[TD="class: xl65, align: right"]7774.95[/TD]
[TD="class: xl65, width: 64, align: right"]7782.1[/TD]
[TD="class: xl65, width: 64, align: right"]7773[/TD]
[TD="class: xl65, width: 64, align: right"]7780.25[/TD]
[TD="class: xl65, width: 64, align: right"]2820350[/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 117"]31.07.2014 09:25[/TD]
[TD="class: xl65, width: 64, align: right"]7780.4[/TD]
[TD="class: xl65, width: 64, align: right"]7782.95[/TD]
[TD="class: xl65, width: 64, align: right"]7779.1[/TD]
[TD="class: xl65, width: 64, align: right"]7782.95[/TD]
[TD="class: xl65, width: 64, align: right"]1965300[/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 117"]31.07.2014 09:30[/TD]
[TD="class: xl65, width: 64, align: right"]7785[/TD]
[TD="class: xl65, width: 64, align: right"]7787[/TD]
[TD="class: xl65, width: 64, align: right"]7784.15[/TD]
[TD="class: xl65, width: 64, align: right"]7786.95[/TD]
[TD="class: xl65, width: 64, align: right"]454300[/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 117"]31.07.2014 09:35[/TD]
[TD="class: xl65, width: 64, align: right"]7786.75[/TD]
[TD="class: xl65, width: 64, align: right"]7787[/TD]
[TD="class: xl65, width: 64, align: right"]7782.4[/TD]
[TD="class: xl65, width: 64, align: right"]7784[/TD]
[TD="class: xl65, width: 64, align: right"]646150[/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 117"]31.07.2014 09:40[/TD]
[TD="class: xl65, width: 64, align: right"]7782.3[/TD]
[TD="class: xl65, width: 64, align: right"]7784.7[/TD]
[TD="class: xl65, width: 64, align: right"]7775.5[/TD]
[TD="class: xl65, width: 64, align: right"]7775.55[/TD]
[TD="class: xl65, width: 64, align: right"]2341700[/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 117"]31.07.2014 09:45[/TD]
[TD="class: xl65, width: 64, align: right"]7778.25[/TD]
[TD="class: xl65, width: 64, align: right"]7780.5[/TD]
[TD="class: xl65, width: 64, align: right"]7777[/TD]
[TD="class: xl65, width: 64, align: right"]7778.4[/TD]
[TD="class: xl65, width: 64, align: right"]1116950[/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 117"]31.07.2014 09:50[/TD]
[TD="class: xl65, width: 64, align: right"]7777.5[/TD]
[TD="class: xl65, width: 64, align: right"]7778.25[/TD]
[TD="class: xl65, width: 64, align: right"]7773.7[/TD]
[TD="class: xl65, width: 64, align: right"]7774.25[/TD]
[TD="class: xl65, width: 64, align: right"]1202000[/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 117"]31.07.2014 09:55[/TD]
[TD="class: xl65, width: 64, align: right"]7776.25[/TD]
[TD="class: xl65, width: 64, align: right"]7777[/TD]
[TD="class: xl65, width: 64, align: right"]7774.6[/TD]
[TD="class: xl65, width: 64, align: right"]7775.9[/TD]
[TD="class: xl65, width: 64, align: right"]2081850[/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
</tbody>
but i want to paste every 15 minutes data on G H I J K L column respectively.
suppose at now time 9.00 AM when time 9.15 AM that data automatically paste on another mention column G H I J K L respectively .
is it possible ?
<tbody>
[TD="class: xl65"]A
[/TD]
[TD="class: xl65, align: right"]B
[/TD]
[TD="class: xl65, width: 64, align: right"]C
[/TD]
[TD="class: xl65, width: 64, align: right"]D
[/TD]
[TD="class: xl65, width: 64, align: right"]E
[/TD]
[TD="class: xl65, width: 64, align: right"]F
[/TD]
[TD="class: xl65, width: 64, align: right"]G
[/TD]
[TD="class: xl65, width: 64, align: right"]H
[/TD]
[TD="class: xl65, width: 64, align: right"]I
[/TD]
[TD="class: xl65, width: 64, align: right"]J
[/TD]
[TD="class: xl65, width: 64, align: right"]K
[/TD]
[TD="class: xl65, width: 64, align: right"]L
[/TD]
[TD="class: xl65"]31.07.2014 09:20
[/TD]
[TD="class: xl65, align: right"]7774.95[/TD]
[TD="class: xl65, width: 64, align: right"]7782.1[/TD]
[TD="class: xl65, width: 64, align: right"]7773[/TD]
[TD="class: xl65, width: 64, align: right"]7780.25[/TD]
[TD="class: xl65, width: 64, align: right"]2820350[/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 117"]31.07.2014 09:25[/TD]
[TD="class: xl65, width: 64, align: right"]7780.4[/TD]
[TD="class: xl65, width: 64, align: right"]7782.95[/TD]
[TD="class: xl65, width: 64, align: right"]7779.1[/TD]
[TD="class: xl65, width: 64, align: right"]7782.95[/TD]
[TD="class: xl65, width: 64, align: right"]1965300[/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 117"]31.07.2014 09:30[/TD]
[TD="class: xl65, width: 64, align: right"]7785[/TD]
[TD="class: xl65, width: 64, align: right"]7787[/TD]
[TD="class: xl65, width: 64, align: right"]7784.15[/TD]
[TD="class: xl65, width: 64, align: right"]7786.95[/TD]
[TD="class: xl65, width: 64, align: right"]454300[/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 117"]31.07.2014 09:35[/TD]
[TD="class: xl65, width: 64, align: right"]7786.75[/TD]
[TD="class: xl65, width: 64, align: right"]7787[/TD]
[TD="class: xl65, width: 64, align: right"]7782.4[/TD]
[TD="class: xl65, width: 64, align: right"]7784[/TD]
[TD="class: xl65, width: 64, align: right"]646150[/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 117"]31.07.2014 09:40[/TD]
[TD="class: xl65, width: 64, align: right"]7782.3[/TD]
[TD="class: xl65, width: 64, align: right"]7784.7[/TD]
[TD="class: xl65, width: 64, align: right"]7775.5[/TD]
[TD="class: xl65, width: 64, align: right"]7775.55[/TD]
[TD="class: xl65, width: 64, align: right"]2341700[/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 117"]31.07.2014 09:45[/TD]
[TD="class: xl65, width: 64, align: right"]7778.25[/TD]
[TD="class: xl65, width: 64, align: right"]7780.5[/TD]
[TD="class: xl65, width: 64, align: right"]7777[/TD]
[TD="class: xl65, width: 64, align: right"]7778.4[/TD]
[TD="class: xl65, width: 64, align: right"]1116950[/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 117"]31.07.2014 09:50[/TD]
[TD="class: xl65, width: 64, align: right"]7777.5[/TD]
[TD="class: xl65, width: 64, align: right"]7778.25[/TD]
[TD="class: xl65, width: 64, align: right"]7773.7[/TD]
[TD="class: xl65, width: 64, align: right"]7774.25[/TD]
[TD="class: xl65, width: 64, align: right"]1202000[/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 117"]31.07.2014 09:55[/TD]
[TD="class: xl65, width: 64, align: right"]7776.25[/TD]
[TD="class: xl65, width: 64, align: right"]7777[/TD]
[TD="class: xl65, width: 64, align: right"]7774.6[/TD]
[TD="class: xl65, width: 64, align: right"]7775.9[/TD]
[TD="class: xl65, width: 64, align: right"]2081850[/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
[TD="class: xl65, width: 64, align: right"][/TD]
</tbody>
Last edited: