Excel vba help to copy data from another workbook to list of excel files in a folder

[tanmaysingh]

Hello
New to EXCEl VBA , but this community is known to help a newbie become pro users
My requirement is simple.
I ve around 200 excel files with names like NAME1,NAME2.NAME3.....ETC... IN A FOLDER.
I ve another Sheet1 in Book1 where correspoing to each NAME1,NAME2,NAME3 IN COLUMN A,i ve data in COLUMN lets say
B,C,D. For each NAME1 in column A, i want to open the file NAME1 in my folder, go to the Sheet3 in the NAME1 file and
update cells B1,c1,D1(THIS would be constant cells) with the data in column B,C,D of the Book1.
Note : The order of Name1,name2,name 3 is exactly be the order in which the files in my folder is arranged alphabetically
,so i would not need a functionality to match the file name to the column A of the Book1.
so basically , i am looking to loop through various files in a folder and update a specific colummn of a specific sheet in the workbook, from another workbook
which is open So basically
EXCEL named NAME1.Sheet3.CellsB1,c1,D1 would copy data from
EXCEL BOOK1, sheet1, CellB1,C1,D1 EXCEL NAME2.Sheet3.CellsB1,C1,D1 Would copy data from
EXCEL BOOK1, sheet1, CellB2,C2,D2 and so on.

Am sure many users would have wanted this simple functionality, so any small VBA code, or
reference to any code already present in the forum would be helpful.

 

[kumarapush123]

Actually you are trying to refer external Excel file from your Active Excel Workbook. To do this, you have understand how to refer other workbooks from working Excel Document. Refer this link to know how to do it.

Different Methods to Import Data From External Excel File

 

[tanmaysingh]

Hello @kumarapush123, Thanks a ton for the immediate reply.How ever, this is not exactly i was looking for.I dont think the link answers all the questions.
Actually i am not looking to update data in a single excel, single cell from any other excel.But i want to loop through 200+ excel files placed in a folder with sequential names.
These names and the data i need to pull (to update in sheet XX, Cell YY of my 200+excel files in the folder)are present in another excel file.So i just need a macro that would loop through all the rows in the external file and update them to the YY cell of each of the 200+ excel file..Any help?