hello team ,
i am making a process in that i need to first merge the folder’s that is located at different path and i need to merge them in that way so that my second excel all details will be seen in the first excel as per each emp 's and i m not able to find how to do
can anyone help? Analytics and AI(2).xlsx (429.8 KB)
no this isn’t same in previous ca Main.xaml (15.7 KB)
se i just need to merge the file but in this case my excel file are located at different folder’s path and i need to fetch the specific file from both of the folders and merge them as in both the folder’s i have two excel’s files with different name and in each excel in have sub sheets and need to merge the sheets too but before that i need to merge the excels i.e is located at different folder’s paths .
I have done this but with this my 2 excels that is located in same path are merging as i dont want to merge them i need to merge excels of same contend with different path