Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sharing read-write Excel 2003 files | Excel Discussion (Misc queries) | |||
Issue opening csv files in Excel | Excel Discussion (Misc queries) | |||
Importing multiple Text files into Excel 2003 | Excel Discussion (Misc queries) | |||
Importing text files to Excel with big numbers | Excel Worksheet Functions | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) |