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.
Create a VBA to copy the same cell on every file in a folder and copy to another workbook.
-
Jonnyboisme -
March 15, 2021 at 8:32 PM -
Thread is marked as Resolved.
-
-
-
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 ...
-
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.
-
-
No the file name changes each week. The workbook structure remains the same, but the data and number of files changes. We need to paste that data to another workbook to upload the data to the system. I have attached a word doc with some screenshots. RFL Information.docx
-
-
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
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!