Opening new workbook and pasting values into current workbook - code issues

**Stew1234** · 05-13-2014, 12:07 PM

Hi all,

I am using the below code (i have combined different bits of code which i found on these forums) to open a new workbook, copy all the data in it and paste it into Sheet2 in the active workbook . Also, i want the data to be pasted on the next empty row as there is already data in Sheet2. The data that is being copied and pasted has the same format and it is going to be repeated many times.

The problem i am having is that it is not offsetting the data to the next empty row - i think it is a simple change but i can't seem to get there :s

Also, the code is currently selecting all of the data from the workbook that i open - is there a way i can select all of the data, excluding the first row (the first row contains the headings which i already have in Sheet2 in the active workbook).

Thanks in advance!

Stew

Please Login or Register  to view this content.

**Rschwar23** · 05-13-2014, 01:13 PM

Hi Stew,

Could it be that

Please Login or Register  to view this content.

should be

Please Login or Register  to view this content.

?

**Leith Ross** · 05-13-2014, 01:20 PM

Hello Stew1234,

The code should work now.

Please Login or Register  to view this content.

**Norie** · 05-13-2014, 01:30 PM

Try this.

Please Login or Register  to view this content.

**Stew1234** · 05-14-2014, 11:03 AM

Thanks for the quick response everyone - Norie your change seemed to do the trick.

As always, really appreciate everyone's help!

**Max_excel** · 05-15-2014, 07:56 AM

Nice work Norie.. Above code is almost perfect for me, but would you be able to make this code run for data based on the headers? I have a spreadsheet which have headers from Col A to AM and I want paste data from only few columns to my main sheet. Please note data is to be pasted on the next empty row.

Data should be pasted from test sheet to the master sheet in next empty row but as per the column headers. Sequence of the headers may not be same every time.