GerryZ
Well-known Member
- Joined
- Jul 4, 2014
- Messages
- 1,224
- Office Version
- 365
- Platform
- Windows
hello Every Body!
In the table on the left I have a WebQuery Table that every time I clik The bottom UPDATE it automatically UPDATE but my problem is that I need to extract every 5 minutes the update change from U$A/€URo to add in the column L
So I need to extract the change in B8 e put in column L in corrisponding time
I Belive I need a Macro or a VBA code that I'm not very good
thank you for your help
In the table on the left I have a WebQuery Table that every time I clik The bottom UPDATE it automatically UPDATE but my problem is that I need to extract every 5 minutes the update change from U$A/€URo to add in the column L
So I need to extract the change in B8 e put in column L in corrisponding time
I Belive I need a Macro or a VBA code that I'm not very good
thank you for your help
| Book1 | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | |||
| 4 | ||||||||||||||
| 5 | Cambio tra le principali valute | 09:00:00 | 1,04960 | |||||||||||
| 6 | USD | EUR | CHF | GBP | JPY | CAD | AUD | 09:05:00 | 1,04960 | |||||
| 7 | 1 USD | - | 0,949400 | 1,005000 | 0,6766 | 121 | 1,277 | 1,307 | 09:10:00 | 1,05150 | ||||
| 8 | 1 EUR | 1,0533 | - | 1,058600 | 0,7127 | 128 | 1,345 | 1,376 | 09:15:00 | ? | ||||
| 9 | 1 CHF | 0,995 | 0,944600 | - | 0,6732 | 121 | 1,271 | 1,300 | 09:20:00 | ? | ||||
| 10 | 1 GBP | 1,478 | 1,403100 | 1,485300 | - | 179 | 1,887 | 1,931 | 09:25:00 | ? | ||||
| 11 | 09:30:00 | ? | ||||||||||||
| 12 | 1 JPY | 0,0082 | 0,0078 | 0,0056 | 0,0056 | - | 0,0105 | 0,0108 | 09:35:00 | ? | ||||
| 13 | 09:40:00 | ? | ||||||||||||
| 14 | 1 CAD | 0,7832 | 0,7435 | 0,7871 | 0,5299 | 95 | - | 1 | 09:45:00 | ? | ||||
| 15 | 1 AUD | 0,7653 | 0,7265 | 0,7691 | 0,5178 | 93 | 0,9771 | - | 09:50:00 | ? | ||||
| 16 | 09:55:00 | ? | ||||||||||||
| 17 | 10:00:00 | ? | ||||||||||||
| 18 | 10:05:00 | ? | ||||||||||||
| 19 | 10:10:00 | ? | ||||||||||||
| 20 | 10:15:00 | ? | ||||||||||||
| 21 | 10:20:00 | ? | ||||||||||||
| 22 | 10:25:00 | ? | ||||||||||||
| 23 | 10:30:00 | ? | ||||||||||||
| 24 | 10:35:00 | ? | ||||||||||||
| 25 | 10:40:00 | ? | ||||||||||||
| 26 | 10:45:00 | ? | ||||||||||||
| 27 | 10:50:00 | ? | ||||||||||||
| 28 | 10:55:00 | ? | ||||||||||||
| 29 | 11:00:00 | ? | ||||||||||||
WEB QUERY (EP58) | ||||||||||||||
