I have 10 excel file. I need to change same cell in all the files at once.Let the file name be x1,x2,x3 etc.If file name = x1, the cell c1 to be added with "1"..Similarly if file name =x2, cell c1="2"....How to do
