Hi There,
It’s been a while since I have been on this forum. I have a question that I hope you can help me with.
I have a number of Excel (xlsm) files in a folder. Within each file are a large number of sheets. I need to extract data from each sheet. The worksheet names have the following structure: MonDAY_Prod1, MonDAY_Prod2, MonNGT_Prod1, MonNGT_Prod2 etc.. There can be over 28 sheets in each file. I only need the data from the sheets with the word ‘Prod’ in the Worksheet name.
There can be up to 52 file in the folder and all have the following filename structure: DOC0056423 - Scrap workbook Week 52.xlsm. Each filename is the same except for the week number which will range from 01 to 52. Only the files that I need data from will be in the folder
Within each sheet in each file I need to copy cells Q42:Q62 to a master file for the year. I would like each of the pasted data cols from each worksheet to have the Worksheet name above it. And each of the rows to have the filename in the leftmost cell. Please see the example below.
I’ve found a number of solutions to copy from sheets or files but not something that does multiple files and sheets and pasts in a way that I can track the data.
I hope this is clear enough, please let me know if you need any more detail.
Thank you very much
It’s been a while since I have been on this forum. I have a question that I hope you can help me with.
I have a number of Excel (xlsm) files in a folder. Within each file are a large number of sheets. I need to extract data from each sheet. The worksheet names have the following structure: MonDAY_Prod1, MonDAY_Prod2, MonNGT_Prod1, MonNGT_Prod2 etc.. There can be over 28 sheets in each file. I only need the data from the sheets with the word ‘Prod’ in the Worksheet name.
There can be up to 52 file in the folder and all have the following filename structure: DOC0056423 - Scrap workbook Week 52.xlsm. Each filename is the same except for the week number which will range from 01 to 52. Only the files that I need data from will be in the folder
Within each sheet in each file I need to copy cells Q42:Q62 to a master file for the year. I would like each of the pasted data cols from each worksheet to have the Worksheet name above it. And each of the rows to have the filename in the leftmost cell. Please see the example below.
I’ve found a number of solutions to copy from sheets or files but not something that does multiple files and sheets and pasts in a way that I can track the data.
I hope this is clear enough, please let me know if you need any more detail.
Thank you very much