Check out Ron de Bruin's site for code to pull from closed workbooks.

http://www.rondebruin.nl/ado.htm


Gord Dibben MS Excel MVP

On Sun, 24 Sep 2006 17:37:01 -0700, STOVK
wrote:

Hello All,

I use a template to complete a weekly Expense Report. On every report the
cell J30 is always the Total dollar amount

What I would like to do is create another Excel worksheet that imports just
cell J30 from all of my past Expense Reports to get a running tally. Other
than opening each file (200+) and linking the data or cutting and pasting, is
there an easier way?

Thank you