Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have multiple randomly named contracts files in a folder(saved as Customer
name, last name,first name). They are placed in this folder based on cell data for the month the contracted work is scheduled (masterU3). What I would like to do is extract the dollar total for each job (masterw29) found in this folder and compile a list by week for the total amount contracted each week. This way I can better judge the way I schedule the work. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Extract Info from Multiple files | Excel Worksheet Functions | |||
Summarizing the data from all the files in a folder | Excel Discussion (Misc queries) | |||
Macro: Filter Multiple header then extract to Multiple Files | Excel Discussion (Misc queries) | |||
Extract Data from Multiple Excel Files | Excel Discussion (Misc queries) | |||
extract key words/data from multiple files -dump in new worksheet | New Users to Excel |