• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

copy and paste the data from two files into one files

1.xlsm is located in C:\Users\user\Desktop
2.xlsm is located in C:\Users\user\Desktop

i will place the code in third file it is named as book2
see the result in book2 in sheet1

i am attaching all three file plz look into it
 

Attachments

  • 1.xlsm
    16.7 KB · Views: 4
  • 2.xlsm
    16.6 KB · Views: 4
  • Book2.xlsx
    16 KB · Views: 3
Something like that?
open Example (merge) workbook
push button
find Workbook 1 and 2 done
unzip first
 

Attachments

  • leonardo (merge).zip
    46.2 KB · Views: 4
Belleke this code is best of best
but i need a code that automatically select the file bcoz i have provided the location of the file and name of the file
So plz look into this once again and do needful
 
Back
Top