Real time table generation

[boschow]

Hi all, i am useing Excel 2003 and OPC server client for excel, and i am monitoring 6 values, that are changeing each second. I was trying to make a function to collect this information, so i could form a statistic table, but unfortunally with no success. I can watch how the values are changeing their numbers, but i cant sotre the values in the rows below. Does anyone know how can i do this, i have a big lack of knowlage in this field and i am asking you for your help.

Yes i know that Excel has a limit of rows. So i wanted to start a new table in a new worksheet when the maximum number of rows is reached. About the 6 variables, they are changeing in time periods that are shorter then 1 second, but i just want to capture them in a 1 second period. But ther is a problem, i tryed to do it with a macro, but when i started the macro, the numbers froze??
I dont know why, maybe you have a solution for this too?

Thank you very much
Regards
Boschow!