Summarizing data from multiple sources

[woodjockey]

I am new to VBA programming. I hope someone can assist me. At the end of each production day the individual assembly areas will update a workbook with their daily finishes. Management has requested an Excel workbook that would collect and display all of the daily finishes from the assembly areas. There are 3 different assembly areas, each with their own workbook. The individual workbooks are called "Small Assembly 2018", "Medium Assembly 2018", and "Large Assembly 2018". Each of these workbooks contain a separate worksheet for each month, Jan 2018, Feb 2018, etc. All of the worksheets are formatted the same. The day of the month is displayed in in columns D5:AH5. Under each day of the month in D6:AH6 is the "Plan" for each day. In D7:AH7 is the "*** Plan". In D8:AH8 is "Actual". This is were the daily production numbers will be entered. In D9:AH9 is "*** Actual". The labels for the 4 sets of data are in C6:C9. These workbooks all reside in a folder at C:\Building B\Daily Production. Each morning our director wants to execute a spreadsheet called "Daily Production" to see how each assembly area did the day before. This spreadsheet resides in C:\Management\Daily Reports. The report date will be in C1. The data from the individual workbooks will be displayed: Small assembly - A4 "Plan:", B4,"___", C4 "Actual:", D4 "____", E4,"*** Plan:", F4 "____", G4 "*** Actual:", H4 "____". The data for the Medium line will be formatted the same way in Row 9. The Large line will be displayed in Row 14. I summary, the management workbook will need to get data from the individual assembly area workbooks based on the date.

[xladept]

Attach a couple of sample workbooks. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[woodjockey]

I have attached 2 workbooks. In "Small Line 2018" the assemblers will record their daily finishes. As you can see there is a worksheet for each month. The only data that I am currently interested in is the "Daily Completions". They will enter the daily completions in row 8 under the appropriate day of the month. There are 3 assembly workbooks: Small Line 2018.xlsx, Medium Line 2018.xlsx, and Large Line 2018.xlsx. These 3 workbooks will reside in the same folder. I only attached 1 of the 3. The attachment "Daily Productivity.xlsx" is the management workbook that will contain the summary data. The date is displayed in C1. This management summary will expand as our new processes are being developed. all I care about at this time is the 4 pieces of data coming from each of the individual assembly workbooks and populating the management summary. I hope this gives what you need. Again, thank you very much for your help.

[dominicb]

Cross-posted : https://www.mrexcel.com/forum/excel-...books-vba.html

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).