Hey guys,

I have a spreadsheet for an online game which pulls data in XML form.

The data is transaction data, but the game only stores the last 1000 transactions in its memory. Hence, when I pull the data into Excel, all that seems to be happening is old stuff is getting deleted and new stuff is replacing it - it's just scrolling, basically.

What I'd like to do is have the XML pull the data, and then each record (each transaction has a unique ID) is permanently saved in my workbook. I could, of course, make a new worksheet every time - but then I'd have a bunch of duplicate records unless I timed each refresh exactly 1000 transactions apart.

Hopefully I've explained myself clearly enough, and thanks in advance!

Ellessarr