Thread: Data Compilation

Dear all,

I need to accumulate data from 21 workbooks to a destination workbook sheetwise
Detail information of the source data are:
Directory: E:\BB_SUBMISSION-FE26\BRANCH_DATA
Number of workbooks in E:\BB_SUBMISSION-FE26\BRANCH_DATA\ : 21 Workbooks; the workbooks are named as AGARGAON.xls, Agrabad.xls, BAN.xls, BNG.xls, CDA.xls, CORP.xls, DHN.xls, GB.xls, IMG.xls, JB.xls, KLN.xls, KRN.xls, KTG.xls, LDP.xls, MB.xls, NARAYANGONJ.xls, NER.xls, PB.xls, SHYAMOLI.xls, UB.xls.
Sheet Name: Each of the 21 workbooks has a worksheet named "Sheet1".
Copy from range: F115: J117, F121: J128, K132: O133, K135: O137
I need to copy data from "Sheet1" in each of the 21 workbooks and paste data to 21 worksheets in a destination workbook with 28 worksheets.
Detail information of the destination data
Directory: E:\BB_SUBMISSION-FE26
Destination workbook name: ANNEXURE-B.xls
Destination worksheet names are: AGARGAON, Agrabad, BAN, BNG, CDA, CORP, DHN, GB, IMG, JB, KLN, KRN, KTG, LDP, MB, NARAYANGONJ, NER, PB, SHYAMOLI, UB
Destination range: F115: J117, F121: J128, K132: O133, K135: O137

How is this different from the previous post we discussed? Is it the same thing, but now with multiple books? If so, we should just modifiy the solution that I have already provided.

Originally Posted by Mallycat

How is this different from the previous post we discussed? Is it the same thing, but now with multiple books? If so, we should just modifiy the solution that I have already provided.

Hi, Matt

Earlier, we copied selected range from one workbook to another workbook. The problem now is to copy data from 21 workbooks and paste is to a single workbook with 28 worksheets.

Hope the problem is clear to you. Waiting for your solution

It's basically the same problem, it's just that you are copying the data from a different starting point. If you post back the last version of the B file including my code, I will modify it for you. Do you still want it to work the old way, or do you want it to work the new way only? Is there anything else you want to do after this? :-)

Originally Posted by Mallycat

It's basically the same problem, it's just that you are copying the data from a different starting point. If you post back the last version of the B file including my code, I will modify it for you. Do you still want it to work the old way, or do you want it to work the new way only? Is there anything else you want to do after this? :-)

I am attaching the files to your mail

It doesn't appear to be there

Dear Matt

I am attaching the files

Originally Posted by Rashed.R

Dear Matt

I am attaching the files

Dear Matt,

One more thing, I want to run the macro from my destination file "ANNEXURE-B.xls'