I have a speadsheet that is trending real time data for a process. I need to get a separate worksheet to reference/capture only the final, say 20, data points in each column of the real time data, even when more data has been added. The intention is to link this second spreadsheet to minitab in order to provide real time charting.

Can anyone help?