View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
STOVK STOVK is offline
external usenet poster
 
Posts: 1
Default 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