Hi Experts,
Hope you all are safe and doing good.
I need a heling hand making my code more dynamic so that I do not have to click and choose files one by one.
I have a folder where I place multiple reports . I also have a Master sheet, where I have my code and want to copy data to the sheet name "Data" in my master sheet from the other files placed in that folder.
Lets say I have a Report named as "Query" placed in the folder. I will run the VBA and when filename = Query, then it will copy data from that report and paste it in Master workbook sheet "Data".
Please note all the reports placed in folder will have only 1 sheet, but the names might not be the same. So we can take the sheet number instead so that I do not have to be worried about the names.
So my goal is, if I have 5 files then i should just click the macro only once and the it will search for the file name, if matches copy the data and paste.
Please Login or Register to view this content.
Bookmarks