VBA to import used range of specific columns to different columns

**Pierce Quality** · 02-13-2014, 11:14 AM

Hello All,
Im looking for a way to import variable data from different columns in two different open workbooks to a master file. In the attached workbook I've given an example of the data in two different books on the Data1 and Data2 worksheets, and what the finished product should look like on the FinishedData sheet.
The code I'm working with is this:

Please Login or Register  to view this content.

and this:

Please Login or Register  to view this content.

There are two different buttons to call each macro. Of course, the current code will copy ALL of the data, and I need it to only grab a specific set of columns, preferably without using the clipboard. In the actual master file, "Test" is the worksheet name the data is copied to.
Any help would be greatly appreciated, Thanks!

**Pierce Quality** · 02-13-2014, 01:28 PM

Bumping along.

**Pierce Quality** · 02-13-2014, 03:56 PM

I've since updated the code to this:

Please Login or Register  to view this content.

And this:

Please Login or Register  to view this content.

Which is on the right track but is only going to copy one cell in the column. What I am stuggling with is how to write the range method to copy the variable range of the data in each column.
Any help would be greatly appreciated, thanks!

**Pierce Quality** · 02-14-2014, 10:15 AM

Bumping along.

**buran** · 02-14-2014, 10:32 AM

Hi,
it's strange nobody answered for so long

Apply such change to all of copy statements

Please Login or Register  to view this content.

**Pierce Quality** · 02-14-2014, 11:18 AM

Originally Posted by buran

Hi,
it's strange nobody answered for so long

Apply such change to all of copy statements

Please Login or Register  to view this content.

Hello buran, thanks for the reply!

That solves the range copy issue, thanks! However, when I initiate the second macro I get a run time error 438 (object does not support this property or method) when it tries to paste the second set of data into that same column. How can I get it to paste in the first open cell in that column?
Thanks!

**buran** · 02-14-2014, 11:25 AM

Can you post your new code. It looks like you have a syntax error

**Pierce Quality** · 02-14-2014, 11:28 AM

Originally Posted by buran

Can you post your new code. It looks like you have a syntax error

Sure thing, here is the first one:

Please Login or Register  to view this content.

And the next:

Please Login or Register  to view this content.

Thanks!

**buran** · 02-14-2014, 11:35 AM

I think it's because you are missing the continuation "_" after Copy

Please Login or Register  to view this content.

**Pierce Quality** · 02-14-2014, 12:04 PM

Originally Posted by buran

I think it's because you are missing the continuation "_" after Copy

Aha! That did the trick!
Thank you very much, marking this as solved!

VBA to import used range of specific columns to different columns

LinkBack

Thread Tools

Rate This Thread

Display

VBA to import used range of specific columns to different columns

Re: VBA to import used range of specific columns to different columns

Update

Re: VBA to import used range of specific columns to different columns

Re: VBA to import used range of specific columns to different columns

Re: VBA to import used range of specific columns to different columns

Re: VBA to import used range of specific columns to different columns

Re: VBA to import used range of specific columns to different columns

Re: VBA to import used range of specific columns to different columns

Re: VBA to import used range of specific columns to different columns

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Import specific columns past a certain row into another spreadsheet.

How to import specific columns from excel file

Macro to import data from specific columns form csv and rearrange

vba only import columns from csv with specific text in row A

import data to specific columns

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions