I have a problem where as I am having 80+ templates for different company, in that we have 1 single raw file. which will update multiple columns and cells based on the number.
I want to open each company file go to the desired sheet name like (11/25/2024) check the data if we have 15 cells figures available then update all the respective cells and close the file. Then same thing will happen open next company file check which type data is there update whatever cells data is available update that eg 7 cells. And this should go on until all the templates are done. I have tried a lot but not getting any idea to move forward. I want someone who can help me please.
