I am not an Excel programmer but am fairly familiar with the functions. I've
been asked by my supervisor for the following:

We will be exporting (monthly) from an accounting system account numbers and
their balances (the export will be in XLS format). These account numbers
never change. He wants to be able to bring those figures into a spreadsheet
(spreadsheet2). Spreadsheet2 should show the account numbers, balances, plus
we need a running total of the balances from previous months for each
account.

Any suggestions on the best way to do this would be appreciated. The best
case scenario would be that we can export the data to a file, open the second
spreadsheet and with a few clicks have the data brought in and have the
information we need.

Thanks in advance.