Copy info from variable workbooks to a masterfile then loop

Hi guys.

I been looking through the internet for a similar code to tweak and use for what i want but i´ve had no luck

Basically, what i have is a master file that needs to pull info from other sources (a simple copy and paste)
those files are called Inventory_xxxx.xlsm . Inside the master file, there are cells with the number of the inventory.
What i need is a way to tell excel to check what number is in the cell, open the files with that number, get the info from the files and paste it back in the master file... and the part that i consider the trickiest, a way to loop it.

For example, lets say i have 2248 in cell A10, it should open Inventory_2248.xlsm copy the contents from cell N4,O4,P4,Q4,R4, and S4(Inventory File) into N10,R10,S10,T10 and U10 (Master file) respectively
then in A11, there could be a 2250 so it should open the 2250 file get the info, paste it and so on.....

now i dont even know if this is do-able or just impossible, been fiddling with various codes to no avail.
Any kind of help would be incredibly appreciated
Thanks in advance

-Batuh

Welcome to the forums!


Nevermind I had to change my post. I saw a terrible flaw in the code. I'm tired.

Please Login or Register  to view this content.

Did this work for you?

Awesome. I am glad it worked for you. Thanks for the rep.