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) |