Macro to Transfer Specific Columns from One workbook to another
Hi,
I need to create a macro that transfers 6 different columns in a raw data workbook to another workbook in order to upload the data.
The problem I am running into is that the cell ranges in the raw data workbook is never going to be the same, therefore I need a code that will only copy the cells with data in them.
I have tried creating a macro by recording and then editing that string of code but I am not very good with excel.
Please Login or Register to view this content.
Last edited by arlu1201; 05-15-2012 at 10:56 AM. Reason: Please put code tags in future.
Hello there,
Try this,
Please Login or Register to view this content.
I also get the same error with line
RD = Windows("Raw Data.xls")
* Run-time error '91:
Object variable or with block variable not set
do you have an example book?
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
Statements like this:
LRow = Range("F1").End(xlDown).Row
Can be broken if you hit a space along the way...you should consider: LRow = SomeSheetVariable.cells(rows.count,6).end(xlup).row
IN fact this block:
Can become:Please Login or Register to view this content.
Please Login or Register to view this content.
---
May look confusing at first, but saves time when running the code. Also, if you need to copy 6 columns out you can turn the macro in to 6 lines like this (or less if the columns are contiguous). Pretty spiffy.
Last edited by GeneralDisarray; 05-15-2012 at 03:51 PM. Reason: Sorry! forgot equals sign...was typing direct w/o the editor to catch that
Here's two sample books.
I am fairly lost here.
Hey there,
Sorry I was kind of winging it without the workbooks.
change the below lines of code
To look like thisPlease Login or Register to view this content.
Please Login or Register to view this content.
This only gave me the top two rows of data.
Okay try changing the below line of code
to thisPlease Login or Register to view this content.
Please Login or Register to view this content.
This returns only 3 lines.
Thanks for your help everyone, this seems to be quite tricky
How many lines should there be? If you go to te document and press Ctrl End where does it take you?
In the example I am trying there is 50 lines, and only the top is being returned. I should note that the top rows in my raw data book have filters so they can be sorted
Then are you trying to copy a filtered selection? That might be why it is only copying the top 3 rows.
Yes right now it is only taking the top row of a filtered section. which is the only row I don't want
Alrighty I think this will do the trick, sorry I wasn't aware that you were filtering rows.
Please Login or Register to view this content.
Thats my bad I should have included that. Works perfectly. Thanks a lot!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks