Vba to run macro for multiple excel files within a folder path

[criscrks]

[h=2][/h]

Hello,


I want to record a VBA that uses =index,(match),0)) formula into the same cell for multiple excel files. The files will be in .XLSX format and will =index,(match),0)) against a separate excel file. I want this function to work for a folder path containing multiple files Please let me know if this makes any sense and if possible.


Here is the example of how the formula will be.

=INDEX(ZAZZZZZZZ.xlsx!$B:$B,MATCH(A2,ZAZZZZZZZ.xlsx!$D:$D,0))



Thanks,
Criscrks​

 

[Eric H]

Hi Criscrks,

I have a few questions if you don't mind.

01.)Are you saying you would like to cycle through the excel files within a target folder and insert the "=Index,(Match),0)) formula into a certain cell within each file?
02.)Or are you saying you want to use the "=Index,(Match),0)) to retrieve data from each of the excel files within a target folder?

I just want to make sure I clear on what exactly is the task you are trying to accomplish.
Thank you in advance.

Eric H

 

[criscrks]

Hey Eric H,

01.) I want to cycle through the excel files within a target folder and insert the "=Index,(Match),0)) formula into a certain cell within each file.

If you could help that'd be amazing.

Thanks,

 

[criscrks]

Hey Eric H,

01.) I want to cycle through the excel files within a target folder and insert the "=Index,(Match),0)) formula into a certain cell within each file.

If you could help that'd be amazing.

Thanks,