Open another excel file and copy data to sheet 2 while button upload is in sheeet 1

Hi all,

Can i ask if you can help me how to copy data from one workbook to another workbook.

here's the process

1. Button upload is in book1 sheet 1
2. Copy data from book to book 1 sheet 2

Here's my code for starters.

Please Login or Register  to view this content.

Originally Posted by rflorentino

Hi all,

Can i ask if you can help me how to copy data from one workbook to another workbook.

here's the process

1. Button upload is in book1 sheet 1
2. Copy data from book to book 1 sheet 2

Here's my code for starters.

Please Login or Register  to view this content.

Got to rephrase the question.

How can I copy by column.

1. In workbook1 sheet 2 there are 4 columns with fix headers namely name, age, height and weight
2. In workbook2 there are 10 columns namely (feet size, name, height, bday, mothersname, fathersname, weight, age, gnder and notes)
3. I want search the workbook2 for name, age, height and weight column only
4. copy those columns in order and paste it in workbook 1