storing cell data and retrieving

[mrclox]

Hi i have a problem someone here may be able to help with. I have a spreadsheet that is refreshed by externel web data every 10 mins or so, I want to be able to store the data in say cells a1-d1 so that i can form a list of all the data that has appeared in those cells . i want to be able to refer back to this list automatically when the sheet is refreshed and use the data to change oither cells... How can i do this?

 

[mrclox]

??????

 

[just_jon]

Might help to post the code you are using for the refresh?

 

[joelnichols]

So you want to save the info from each refresh? Like this maybe?

Book1
	A	B	C	D	E
1		query	time
2			2:00	1:50	1:40
3
4	Intel	?	50	49	48
5	GE	?	40	39	38
6	Yahoo	?	60	59	58
7	IBM	?	30	29	28
Sheet1

 

[mrclox]

yes thats exactly how i want it saved. automatically. I use import data from a web page not code

 

[mrclox]

you have wetted my appetite please tell me more! this is exactly what i want how do i doiT?

 

[mrclox]

????

 

[mrclox]

it must be possible

 

[just_jon]

It depends on whether the update triggers a recognisable event in Excel - don't know if it does since I never have done much web importing.

Put in a change event macro and see if it fires, maybe?