Right now when management needs to summarize our quarterly demand forecast files, each of the various workbooks (one from each of our internal suppliers/plants) are different from each other. I've worked with our buyers to define one template useful to everyone. After we receive our initial data from sales, we'll send the plants a list of the parts they supply. We'll lock these files so the plants can add the info we're requesting but not alter the original data. Each will have the same columns in the same order, but differ in length, and will all be stored in H:\Purchasing\Shared\Demand Forecast\Demand Forecast 2011\2011 DF Analysis. This is the location for the most current files only.
I'm looking for the easiest way to keep the summary file updated with the totals from each of the workbooks in the above folder. I'm thinking someone might have already made a macro for their own use that will cycle through the workbooks in a folder and take the totals from each workbook (maybe the totals are a named range or something?) and can share or send me a link to a similar post.
Thanks for any help!
I'm looking for the easiest way to keep the summary file updated with the totals from each of the workbooks in the above folder. I'm thinking someone might have already made a macro for their own use that will cycle through the workbooks in a folder and take the totals from each workbook (maybe the totals are a named range or something?) and can share or send me a link to a similar post.
Thanks for any help!
