Good Morning Experts,
I've looked through many of the posts and found some things similar to what I'm trying to do, but none were exact fits or entirely close. I'm not even sure if this is possible.
I have many workbooks (about 40-50 currently) that may increase or decrease in quantity.
They all exist in a main folder called Time and each workbook exists in its own sub folder.
The folder names are all different names and contain commas EXAMPLE: Williams, Paul
The file names are also all different and contain commas EXAMPLE: Williams, Paul
Each Workbook contains 2 sheets of importance. they are: "Labor Totals" and "EQ Totals"
I've attached a sample of what the "EQ Totals" sheet looks like in the individual workbooks.
I am needing to combine the data from each workbooks "Labor Totals" and "EQ Totals" sheets into one master workbook. I'd like the Labor Totals to be in a sheet called "Labor Totals" in the master workbook and the"EQ Totals" to be in a sheet called "EQ Totals" in the master workbook. I'd also like to have the name of the workbook the respective data comes from added to the respective worksheet.
For example Cell A would have "Williams, Paul week ending 9-10-2001" with the data from the respective datasheet, workbook, and line after it in cells b - where ever
Question: Is this possible.
Question: Can anyone assist me in writing the code as I know nothing about macros or advanced Excel.
I'd love to make this a 1000 point question but I don't think it will be allowed
Thank you in advance.