Trying to collect data from OPC will only update in 1 cell ,not entire

[Cydog]

I am collecting data from a OPC server. I was able to drag and drop a tag from opc to excel spreadsheet and the
cell updates just fine,example:A2-48.6 , A2-46.3 , A2-47.7.
But what I would like to do is have it update like a datalogger example: A2 47.7 , A3 46.3 , A4 48.6 ,A5 47.8,
A6 45.9,etc. so I can look at previous data.
Is there a way I can increase the "data cell range" within the excel setup, or maybe a formula ,or maybe I need to purchase a add-in for excel to do this?

Thank You so much for your help ,have a great weekend.

 

[jdhilljr]

You should be able to grab the data and populate a history page. From there you could create a page to view the data however you want. If you post what kind of setup you are looking for I could assist you with it. I had created a similar workbook for a collection agency tracking calls and fees.

If you can't stand behind your troops, stand in front of them.
Semper Fidelis

Jim