Why are my macros only picking up this one file that I used as the model excel sheet inside the red one?
@amnahhussain02 inside the macro (red colored) check the action tool setting , I think the replace part might not be correct, can you screen shot the action tool setting?
removed the FileName formula and it's working now. Not sure why.