LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 20
Default Extract cell data from multiple files in one folder

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extract Info from Multiple files DP7 Excel Worksheet Functions 1 May 15th 07 04:38 PM
Summarizing the data from all the files in a folder Raj Excel Discussion (Misc queries) 5 January 19th 07 01:56 AM
Macro: Filter Multiple header then extract to Multiple Files [email protected] Excel Discussion (Misc queries) 9 December 8th 06 10:44 PM
Extract Data from Multiple Excel Files Steven Excel Discussion (Misc queries) 1 November 2nd 06 04:58 PM
extract key words/data from multiple files -dump in new worksheet MikeR-Oz New Users to Excel 10 March 20th 06 08:14 AM


All times are GMT +1. The time now is 08:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"