Vba to run macro for multiple excel files within a folder path
Results 1 to 4 of 4

Thread: Vba to run macro for multiple excel files within a folder path
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jun 2019
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    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

  2. #2
    New Member
    Join Date
    May 2017
    Location
    Time And Relative Dimension In Space
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

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

    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
    Last edited by Eric H; Jul 14th, 2019 at 06:56 PM.

  3. #3
    New Member
    Join Date
    Jun 2019
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    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,

  4. #4
    New Member
    Join Date
    Jun 2019
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    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,

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •