Advice on Creating A Spreadsheet - HELP!
 

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.

Advice on Creating A Spreadsheet - HELP!
 

You would normally use VLOOKUP to do this. You will need to use a cell
to record the name of the previous month's file, and you can then make
use of INDIRECT to get the data from that file, BUT only if the
previous month's file is open at the same time.

Both functions are described in XL Help.

Hope this helps.

Pete

On Apr 17, 2:00*am, NC wrote:
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.