Create a VBA to copy the same cell on every file in a folder and copy to another workbook.

  • I am new at VBA and I can't seem to find anything that would work for what I am trying to accomplish. I have a folder that contains a bunch of workbooks, I am trying to use VBA to write a macro to copy the same cell on every workbook and copy that value in Colum B and once the second file is run copy it below that cell. Any help would be appreciated.

  • Hello and Welcome to the Forum :)


    To be honest with you your question is quite unusual ...


    And right from the start ... you are exposing THE solution ...


    Are you 100% sure this solution is indeed the right one ...???


    Could you explain in a few sentences the problem you are facing ...

    since it could very well be ... that another ' much easier ' path could produce your expected result ...;)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • I have a folder called RFL Worksheets. I created a VBA to create the worksheets and rename then populate the data into the cells. Once my employees populate additional Data I need to extract the value in Cells "B4" and "C49". Then paste values in a different workbook, loop all the files in the folder with the value of the second workbook below the values from the previous one.

  • Based on all the details you have provided ... and given your important number of files ...


    The best solution for you in order to minimize your efforts is to use Power Query ... much more adapted to your situation than VBA


    https://exceloffthegrid.com/power-query-source-cell-value/


    Hope this will help

    :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!