Copy data from one workbook to a specific sheet in another workbook without overriding

**cdhampshire** · 11-30-2017, 04:41 PM

Hello everyone,

I am sorry to bother everyone but I am stuck. I am trying to add a macro which, when activated, takes data from one workbook to a specific sheet in another. the details of what I am trying to achieve is;

1. copy data that is contained within cells B3: F3 and down (ideally the macro will miss out the blanks when the data ends) from Workbook1
2. Paste that data into Sheet1 within Workbook2 into cells A3:E3 down
3. also when it pastes for the data that was already in there not to be overridden

The macro I have tried and failed to us is;

Please Login or Register  to view this content.

Thanks everyone!!

**jolivanes** · 11-30-2017, 07:50 PM

Can the blanks be deleted before copying? If not, no problem.
No 2 and No 3 contradict each other. Forget about them and just call it "to the first empty cell/row in Sheet1, wb2"
If there is data in Sheet1, wb2, are all the columns the same length?
By the looks of it, the 2nd workbook is closed and need to be opened.
Where is the 2nd Workbook saved? Don't need the path but makes things easier (for me anyway)

In the meantime, how far do you get with this? (Need to delete the empties yet.)

Please Login or Register  to view this content.

I don't know if it works if you insert

Please Login or Register  to view this content.

before

Please Login or Register  to view this content.

**jolivanes** · 12-01-2017, 01:06 PM

Since we have nothing to work with, this is another stab in the semi darkness. The previous deleting empties did not work. Maybe this one does.
I don't think that I need to suggest to try it on copies of your workbooks first. With code, gone is gone.

Please Login or Register  to view this content.

Copy data from one workbook to a specific sheet in another workbook without overriding

LinkBack

Thread Tools

Rate This Thread

Display

Copy data from one workbook to a specific sheet in another workbook without overriding

Re: Copy data from one workbook to a specific sheet in another workbook without overriding

Re: Copy data from one workbook to a specific sheet in another workbook without overriding

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] vba code to copy a specific sheet from a closed workbook to the active workbook

[SOLVED] vba copy specific sheet from closed workbook to active workbook

[SOLVED] copy specific sheet from closed workbook to active workbook

vba copy specific sheet from closed workbook to active workbook

[SOLVED] Copy Each Sheet in Workbook to New Specific Workbook

macro to copy data from one workbook to another on specific sheet

copy of sheet from specific workbook to active workbook

Bookmarks

Bookmarks

Posting Permissions