Importing a Value from many Excel Files
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
|