Copy data from different files into 1 workbook under relevant column heading.

**novice81** · 03-16-2009, 07:49 AM

Hi,

I would be having approximately 50 workbooks containing values on different sheets and in different columns. The requirement is that I need to consolidate corresponding values of first column into the main workbook columns.

Also, the files from which data would be copied should go under respective column's heading.

I have attached the files with this post. Please help me as I need it very urgently. Thanks to all in advance who'd reply!

Main workbook name is "Consolidate"
Sample files are "1PS10", "2PS11", "3.PS12" and "4PS13."

PS: It would be great if you can give comments for all crucial lines as I'm novice to VBA programming.

Regards,
Novice

**dustycrockett** · 03-16-2009, 07:58 PM

Having a hard time figuring out whether you just need a program to copy and paste data, or whether you need a program that figures out which file to open, opens it then figures out where the data is (what sheet and column)......

this will copy data from A to Z in one open workbook and paste it into another:

Please Login or Register  to view this content.

**ravishankar** · 03-17-2009, 11:59 AM

Hi
Your details are insufficient. Samples provided should preferably reflect the original data in data type. save the attached file in the same folder as PS11 ... series files. and run the macro
ravi

**novice81** · 03-18-2009, 01:17 AM

Hi buddy, thanks for your help I was able to work it out. Thanks!

Originally Posted by dustycrockett

Having a hard time figuring out whether you just need a program to copy and paste data, or whether you need a program that figures out which file to open, opens it then figures out where the data is (what sheet and column)......

this will copy data from A to Z in one open workbook and paste it into another:

Please Login or Register  to view this content.

**novice81** · 03-18-2009, 01:19 AM

Hi Ravi, thanks for your help I was able to work it out with your code. Thanks!

Originally Posted by ravishankar

Hi
Your details are insufficient. Samples provided should preferably reflect the original data in data type. save the attached file in the same folder as PS11 ... series files. and run the macro
ravi

Copy data from different files into 1 workbook under relevant column heading.

LinkBack

Thread Tools

Rate This Thread

Display

Copy data from different files into 1 workbook under relevant column heading.

Re: Copy data from different files into 1 workbook under relevant column heading.

Re: Copy data from different files into 1 workbook under relevant column heading.

Re: Copy data from different files into 1 workbook under relevant column heading.

Re: Copy data from different files into 1 workbook under relevant column heading.

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions