Copy data from a column from 3 sheets of a workbook to the column of another workbook

**mclav** · 09-26-2011, 03:05 AM

Hi All,

This is my first post. I m a novice in VBA and I seek your expert help and advice for the following problem.

I have 2 excel workbooks, one named Source.xlsx which i receive on a monthly basis and other Destination.xlsx.

The Source workbook has 3 sheets, which contains numerical codes on Column F (in all 3 sheets), which can increase or decrease every month. I need to copy and paste the contents of Column F from all 3 sheets of Source workbook to Column B, Sheet 1 of Destination workbook one after the other, without copying headers. Can someone help me out with a VBA code to achieve this?

Thanks a lot.
Archer

**tigeravatar** · 09-26-2011, 06:58 AM

Archer,

Welcome to the forum! Give the following a try:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

**mclav** · 09-26-2011, 03:31 PM

Hi,

Thanks for the reply.

I get the following error - Error: Object does not support its property or method

Please Login or Register  to view this content.

How do I resolve this error?

Thanks
Archer

**tigeravatar** · 09-26-2011, 04:09 PM

My mistake, should have been:

Please Login or Register  to view this content.

Adjusted code:

Please Login or Register  to view this content.

**mclav** · 09-27-2011, 03:16 AM

Hi,

Thanks a million!!!!

It works like a charm

Before I close this post as solved, I do have a question - As per my understanding, irrespective of the number of sheets, the code will retrieve the required data. If incase, I have to retrieve data from selected sheets only, what do I need to modify?, Should I mention the worksheet names in the code?

Thanks for your time!

Archer

**tigeravatar** · 09-27-2011, 05:48 AM

Yeah, if you only need to pull data from certain sheets you would mention the sheetnames in the code. Adjusted the code so that, in this example, it will only pull data from sheets that are named Sheet1, Sheet2, or Sheet3:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

**mclav** · 09-27-2011, 02:11 PM

Thanks a lot!!! Appreciate your help!!!

Cheers
Archer

Copy data from a column from 3 sheets of a workbook to the column of another workbook

LinkBack

Thread Tools

Rate This Thread

Display

Copy data from a column from 3 sheets of a workbook to the column of another workbook

Re: Copy data from a column from 3 sheets of a workbook to the column of another work

Re: Copy data from a column from 3 sheets of a workbook to the column of another work

Re: Copy data from a column from 3 sheets of a workbook to the column of another work

Re: Copy data from a column from 3 sheets of a workbook to the column of another work

Re: Copy data from a column from 3 sheets of a workbook to the column of another work

Re: Copy data from a column from 3 sheets of a workbook to the column of another work

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions