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
Bookmarks