Auto Paste data in available cell

[GaurangThakar]

Hi..
I'm just started to learn excel.
I wanted solution, I have a made one automated sheet and data refresh every 5 min. I want to paste that data automatically in new available cell. I.e I want to record all data when sheet refresh every 5 min. Is it possible? I'm using excel 2007. Please help.

Thanks.

 

[offthelip]

It is possible to do this, it does depend on how the your sheet is automatically refreshed. If the refresh triggers the worksheet change event then you can put your code to copy the data into that worksheet event. However often I have found that API don't trigger the worksheet change event, in which case what I do is I put something in the worksheet calculate event to look at one of the cells hat gets updated and thus triggers the event.