Copying from multiple workbook to master with references to named sheets

[phappu]

Hi All,

So a bit of vba help please and thanks! I'm looking for a macro that will copy and paste the values in a range of cell from the sheets of one workbook to the sheets of another master workbook. I want a macro that will let me select which second workbook to copy from, and then copy the information from the sheets in the second workbook that are named the same as the sheets in the master workbook.

For example:
workbooks: MasterWorkbook (MWB), DataWorkbook1 (DWB1), DataWorkbook2 (DWB2)

The Master Workbook has sheets named A,B,C,D,E,F,G,H DataWorkbook1 has sheets named A,C,D,F, DataWorkbook2 has sheets named B,E,G,H.

All sheets are formatted the same, the same range of cells needs to be copied for every sheet (should be able to loop this).

I want the macro in the Master Workbook to ask me to select a workbook (ie. DWB1 or DWB2) and then copy the information from a specific range of cells the sheets in the data workbook to the sheets with the same name in the master (ie. A to A, then C to C, then D to D, then F to F for DWB1).

I'm not entirely sure where to start as the data going from and to the specific named sheet is important and I'm not sure how to do that.

Any help would be appreciated!

[Naveed Raza]

Hi

It would be great if you that three sample workbook , its make very easy to solve your query perfectly

[phappu]

I actually managed to figure it out myself using bit and pieces from a bunch of different sources! I'll post the code up for reference when I'm on my main computer, but thanks for offering to help