Data capture

jhaskins · 10-15-2008, 05:18 AM

I have linked live data to an excel spread sheet It changes in real time. I am trying to figure out how to capture and log that data on a time basis. I want to capture it every 15 minutes and log it to use in trend charts. I can not find any way to copy cell info based on formulas??

HELP: Jimmy

**Glaswegian** · 10-15-2008, 05:49 AM

Hi and welcome.

Something like this should work

http://www.mrexcel.com/forum/showthr...live+data+feed

jhaskins · 10-15-2008, 07:57 AM

I took a look at that and still confused I will give it a try though. Is that a macro? or a formula?

I cannot find anything about worksheet change event selection he refers to?

**Glaswegian** · 10-15-2008, 10:31 AM

Hi

It is Visual Basic code - a macro. The code reacts to a change in a cell value - in this case your live feed and updates another sheet with the data. This creates a log file of values, otherwise your live feed would simply overwrite each value. It will likely need some tweaks to suit you - can you post a sample sheet, remembering to remove any sensitive data? You'll need to zip the file. Please also detail what values you would like and where you would like them to go. Might take me a day or two (really busy at the moment) but shouldn't be too much of a problem.

10-15-2008, 05:18 AM	#1 (permalink)
jhaskins Registered User Join Date: Oct 2008 Location: San Antonio Posts: 2 OS: xp	Data capture I have linked live data to an excel spread sheet It changes in real time. I am trying to figure out how to capture and log that data on a time basis. I want to capture it every 15 minutes and log it to use in trend charts. I can not find any way to copy cell info based on formulas?? HELP: Jimmy

10-15-2008, 05:49 AM	#2 (permalink)
Glaswegian Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic Join Date: Sep 2005 Location: Glasgow Posts: 25,408 OS: Win XP Pro SP3 / Win 7 Pro My System Blog Entries: 10	Re: Data capture Hi and welcome. Something like this should work http://www.mrexcel.com/forum/showthr...live+data+feed __________________ Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums. PC Safety & Security::PC running a bit slow?::Donate::Photographers Corner

10-15-2008, 07:57 AM	#3 (permalink)
jhaskins Registered User Join Date: Oct 2008 Location: San Antonio Posts: 2 OS: xp	Re: Data capture I took a look at that and still confused I will give it a try though. Is that a macro? or a formula? I cannot find anything about worksheet change event selection he refers to? Last edited by jhaskins; 10-15-2008 at 08:08 AM. Reason: can not find worksheet change event

10-15-2008, 10:31 AM	#4 (permalink)
Glaswegian Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic Join Date: Sep 2005 Location: Glasgow Posts: 25,408 OS: Win XP Pro SP3 / Win 7 Pro My System Blog Entries: 10	Re: Data capture Hi It is Visual Basic code - a macro. The code reacts to a change in a cell value - in this case your live feed and updates another sheet with the data. This creates a log file of values, otherwise your live feed would simply overwrite each value. It will likely need some tweaks to suit you - can you post a sample sheet, remembering to remove any sensitive data? You'll need to zip the file. Please also detail what values you would like and where you would like them to go. Might take me a day or two (really busy at the moment) but shouldn't be too much of a problem. __________________ Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums. PC Safety & Security::PC running a bit slow?::Donate::Photographers Corner