Capture Data from Cell

**delboy2405** · 10-26-2007, 01:01 PM

Hi Newbie here,

My excel knowledge is average.

I have 2 cells

I'm extracting data from a program i have.

Cell A1 Counts down to 00:00:00
Cell A2 has data that is refreshed every time its changes(min 1 sec)

I'm looking to capture the data from 00:05:00 down to 00:00:00 in a different sheet. I want to capture both cell contents.

Does anyone know how to do this with functions or do i need VBA???

**mrice** · 10-26-2007, 01:32 PM

Try this event driven macro which needs to be pasted into the VBA tab corresponding to the sheet in which your changing data resides. You'll need to have an additional sheet Sheet2.

Please Login or Register  to view this content.

**delboy2405** · 10-26-2007, 01:49 PM

Just let you know my code is on sheet 2 and i have data on Sheet3 as well.
So i copied and pasted below into sheet 4 in the microsoft visual code screen
under sheet 2, but nothing is happening in sheet 4 as i take it thats where the data would be copied to

Please Login or Register  to view this content.

Please forgive me as i've got very little vba experience

**VBA Noob** · 10-26-2007, 01:53 PM

Please read forum rules below. In future you should post to the correct group (I've moved this thread to programming) and all code must be wrapped (I wrapped the code).

VBA Noob

**mrice** · 10-26-2007, 05:09 PM

Can you post a zipped copy of the file itself? This would help.

**delboy2405** · 10-26-2007, 05:18 PM

Hi,

This is the actual spreadsheet that i'm working on.

As you have not got the program i'm using you'll not be getting any live data.

But i'll explain how it works, Under data sheet > D2, The clock will be counting down.

Cell H9 will be changing at same time. What i'm looking to do is on TIME sheet is to store all the data in H9 and have a time stamp using D2