| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Total sum based on file name
I have one "TOTALS" worksheet where I need to display a total. I need
to cycle through a folder full of excel files, and if the name of the file begins with "Branch" (as in "Branch19Sales.xls") I need to sum up cell C6 on those files in my "TOTALS" worksheet. TIA -Mike *** Sent via Developersdex http://www.developersdex.com *** |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| assign value based on criteria and total | Excel Discussion (Misc queries) | |||
| Grand total based on sub-total | Excel Discussion (Misc queries) | |||
| total amount based on selections of 1-9, 10-19 and 20-30 | Excel Discussion (Misc queries) | |||
| get a total based on criteria in two columns | Excel Worksheet Functions | |||
| total based on one constant value | Excel Discussion (Misc queries) | |||
Threaded Mode
