Copy info from different workbooks into a consolidating file

[papasioux]

Dear Members,

I would like your kind help with the following. I have a consolidate file that collects information from several xlsm files. The xlsm files are in a subfolder with the name of a Project. Inside each Project subfolder there is a file called Pn.xlsm.
I have been strugling on making a code that updates automatically on the Consolidate file, all changes done in each Pn file.
Basically what I´m looking for is a code that copy the range B5:N21 of the Pn.xslm file on each project folder and paste it in a specific range inside Consolidating xlsm, depending on the Project.
For example:
The location of the Consolidating file is: 'E:\Project Control\[Consolidate.xlsm]
The location of Project XXXX is : E:\Project Control\Project XXXX\[Pn.xlsm] and the information should be updated on the range B15:N31
The location of Project YYY is : E:\Project Control\Project YYYY\[Pn.xlsm] and the information should be updated on the range B36:N52
The location of Project ZZZ is : E:\Project Control\Project ZZZZ\[Pn.xlsm] and the information should be updated on the range B57:N73

I hope the examples are clear!

[maniacb]

We would have to see samples of both the Pn and the Consolidate file to write appropriate code to carry out this update. See yellow banner above for instructions.

[papasioux]

Thanks for replying! I have added both files as you suggested

[maniacb]

The two files do not look like the data you outline in your first post. It may be because some data is suppose to update via links we don't have.

[papasioux]

Yeah, I change it since I was getting a problem with that way. I managed to make a macro that opens both files but the problem I got into was that the numbers were correct as long as I keep the books open. for avoiding keeping references to other books I am trying to get the macro that copy from one book to another and then to copy again the values as I explained in the new post

[maniacb]

It's clear where you want to enter data into the consolidate file. But the Pn file looks just like the consolidate file. It's not clear where you want to pull data from. Shouldn't there be just one are in each Pn file that gets pulled into Consolidate file that will house many project statuses?

[jindon]

.........................

[jindon]

Basically what I´m looking for is a code that copy the range B5:N21 of the Pn.xslm file on each project folder and paste it in a specific range inside Consolidating xlsm, depending on the Project.
For example:
The location of the Consolidating file is: 'E:\Project Control\[Consolidate.xlsm]
The location of Project XXXX is : E:\Project Control\Project XXXX\[Pn.xlsm] and the information should be updated on the range B15:N31
The location of Project YYY is : E:\Project Control\Project YYYY\[Pn.xlsm] and the information should be updated on the range B36:N52
The location of Project ZZZ is : E:\Project Control\Project ZZZZ\[Pn.xlsm] and the information should be updated on the range B57:N73

This is to update the corresponding range based in the Project name(s) found in Col.A.

Please Login or Register  to view this content.