Hi,
as per subject, I have a monthly task where I need to copy columns A to H from a specific tab from 30+ different excel spreadsheets and paste them into my working file that has one tab for each so that i can have a consolidated file. Would there be a way to do this easy and quickly maybe using Power Query. I've tried a system of formulas using INDIRECT but files need to be open for that to work. Bear in mind that the paste need to only occur from columns A-H because in my conso workbook the rest of the columns have other formulas that cannot be overwritten.
Thanks very much for the help
as per subject, I have a monthly task where I need to copy columns A to H from a specific tab from 30+ different excel spreadsheets and paste them into my working file that has one tab for each so that i can have a consolidated file. Would there be a way to do this easy and quickly maybe using Power Query. I've tried a system of formulas using INDIRECT but files need to be open for that to work. Bear in mind that the paste need to only occur from columns A-H because in my conso workbook the rest of the columns have other formulas that cannot be overwritten.
Thanks very much for the help