copy data from multiple workbook to a master workbook

**Ajay45822** · 12-27-2020, 12:06 PM

Hi, we have approx 50 to 200 csv files in the following folder

path is
D:\New folder (4)

now we want to copy data (data from Column A to Column N) from all the work book to a master workbook

in all workbook there is only one sheet and sheet name is same to file name.

Example
Copy Data from one file to master file, Data copies and rows occupied A1 to N500
Now again we are copying data and this time data will be paste on A501

we have not created any master file yet.

**jolivanes** · 12-27-2020, 01:36 PM

Need a sheet named "Master" in the Master Workbook

Please Login or Register  to view this content.

**Ajay45822** · 12-27-2020, 02:08 PM

Thanks jolivanes

we have run the code and found some error

Run-time error '9':

Subscript out of range

when we click on it, its goes to following point

wbk.Sheets(1).Range("A1:N" & wbk.Sheets(1).Cells(Rows.Count, 1).End(xlUp).Row).Copy wb1.Sheets("Master").Cells(Rows.Count, 1).End(xlUp).Offset(1)

note: maybe this is the reason for this
in all workbook there is only one sheet and sheet name is same to file name and all file name are diff.

pls check and update

**jolivanes** · 12-27-2020, 03:14 PM

Do you have a sheet named "Master" in your Master Workbook?

**jolivanes** · 12-27-2020, 06:20 PM

BTW, if you change this

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

It still works

**Ajay45822** · 12-28-2020, 01:32 AM

Thanks jolivanes,

you are right, we have not created any sheet with the name of Master, now we have created and it worked

great

thanks bhai

**jolivanes** · 12-28-2020, 02:29 AM

Thank you for letting us know. Appreciate it and good luck.

copy data from multiple workbook to a master workbook

LinkBack

Thread Tools

Rate This Thread

Display

copy data from multiple workbook to a master workbook

Re: copy data from multiple workbook to a master workbook

Re: copy data from multiple workbook to a master workbook

Re: copy data from multiple workbook to a master workbook

Re: copy data from multiple workbook to a master workbook

Re: copy data from multiple workbook to a master workbook

Re: copy data from multiple workbook to a master workbook

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Copy Data from multiple workbooks to master workbook

Copy the Data from Multiple workbook to Master Workbook as Conslidated

Copy data from one workbook to a master workbook w/ multiple worksheets by a Submit button

Copy data from multiple workbooks into one master workbook

Copy data from multiple workbooks to one master workbook

[SOLVED] copy data from multiple worksheets into master workbook

VBA to copy data from multiple workbooks to Master Workbook

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions