Grabbing dynamic data from a worksheet

[truitt20]

I want to grab dynamic data from a worksheet1 and place it in worksheet2 with the value and a timestamp in the cell next to it. The data in worksheet1 gets refreshed every minute, so I would like the data that is being populated in wrksheet2 to create a list and not get over written.

worksheet1 - 12:36PM data would equal 1234
and at 12:37PM data in wrksheet1 would equal 1578

I would like wrksheet2 to begin to look like:

12:36PM 1234
12:37PM 1578
12:38PM 1456
12:39PM 1545

and so on

Anybody have ideas to help me out?

thanks

 

[SkipVought]

Hi,

Pleas post this question in VBA Visual Basic for Applications (Microsoft) forum707

Skip,

_[red][/red]