Copy same ranges in all excel files in a folder into a single workbook

**ple** · 12-16-2013, 02:17 PM

Hi Everyone,

I'm trying to write a code that copies the same ranges in all files in a folder(C:\Users\ple\Desktop\DTF-CRF) into a master workbook with column headers.
All of the excel files in the folder will contain a sheet named "Screening".
Cells K6 (Patient ID), K7 (Visit), C59 (Name), and P59 (Date) need to be copied from each workbook and pasted into their appropriate columns in the master workbook.
The columns in the master workbook are as followed:
A:A(Patient ID)
B:B(Visit)
C:C(Name)
D:D(Date)

There will also be other excel files added to this folder on a daily basis.

Any help is appreciated.

Regards,
Phil

**JOHN H. DAVIS** · 12-16-2013, 02:47 PM

Maybe:

Please Login or Register  to view this content.

**ple** · 12-17-2013, 03:40 PM

Sorry for the long reply, I was bogged down with other work yesterday and just got around to it today.

I updated the code with my data below. I also added code that pulls from a second sheet that is similar to the 1st sheet.
All of the columns are the same as the first sheet except for rows I, J, and K.
The issue is that when the data for I, J, and K are copied, they are pasted in the first empty cell in that column. I would like for them to be pasted in the same row as all of the other data pulled from that sheet.

Please Login or Register  to view this content.

**JOHN H. DAVIS** · 12-17-2013, 04:02 PM

Which Column would define the last row of data?

**ple** · 12-17-2013, 05:04 PM

"N" will be the last column of data.

**JOHN H. DAVIS** · 12-18-2013, 08:25 AM

Maybe:

Please Login or Register  to view this content.

**ple** · 12-18-2013, 10:03 AM

I've tested the code above and unfortunately it doesn't work. The data is being correctely pulled although the second sheet data is overwriting the first sheet data in the master resulting in the data from the second only.

Copy same ranges in all excel files in a folder into a single workbook

LinkBack

Thread Tools

Rate This Thread

Display

Copy same ranges in all excel files in a folder into a single workbook

Re: Copy same ranges in all excel files in a folder into a single workbook

Re: Copy same ranges in all excel files in a folder into a single workbook

Re: Copy same ranges in all excel files in a folder into a single workbook

Re: Copy same ranges in all excel files in a folder into a single workbook

Re: Copy same ranges in all excel files in a folder into a single workbook

Re: Copy same ranges in all excel files in a folder into a single workbook

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA Code open files in folder, copy text to workbook-Next time folder opened copy only new

excel macro to copy data from multi text files in a folder to a single work sheet

[SOLVED] Copy Values From Each Workbook in Folder to a Single Sheet in New Workbook +Workbook names

Merging particular worksheet from Multiple Files in a folder into a single workbook

Copy a row from 3000 excel files stored in a folder and paste it in a new workbook

Bookmarks

Bookmarks

Posting Permissions