Associate
- Joined
- 18 Oct 2002
- Posts
- 1,863
- Location
- Ammanford, Wales, UK.
Hi All,
Firstly, I'm very un-knowledgeable with VBA, so apologies upfront.
What I'm trying to do;
I have a worksheet called 'SpotLookup' - this queries xe.com for silver prices.
On another worksheet called 'StackerTracker' this is displayed via a simple =SpotLookup!F10 formula.
I have a 3rd Sheet called 'ChartData'
Each time the web query refreshes on the SpotLookup sheet, I would like the value as depicted on the StackerTracker sheet to copy to sheet ChartData and paste a date/time stamp in the next cell, and move to the next row for the next update.
I've tried various things that I've gleaned from google and for a while I could get it to update when I manually changed it, but not when the webquery automatically refreshed.
Any help would be greatly appreciated.
Firstly, I'm very un-knowledgeable with VBA, so apologies upfront.
What I'm trying to do;
I have a worksheet called 'SpotLookup' - this queries xe.com for silver prices.
On another worksheet called 'StackerTracker' this is displayed via a simple =SpotLookup!F10 formula.
I have a 3rd Sheet called 'ChartData'
Each time the web query refreshes on the SpotLookup sheet, I would like the value as depicted on the StackerTracker sheet to copy to sheet ChartData and paste a date/time stamp in the next cell, and move to the next row for the next update.
I've tried various things that I've gleaned from google and for a while I could get it to update when I manually changed it, but not when the webquery automatically refreshed.
Any help would be greatly appreciated.