Import data from origenal file to another file

[amy_d2]

Hi ,

i have two files saved in same folder (folder name is Data1122) say for example Book1 & Book2

whereas book1 is Original file where my data is been updated on regular basis, it has approx 15 columns , some blank rows in between, & its 1st row is merge

book2 is the file which needs be over written on everyday 7:00 AM as per Book1 , with limited information of column like only column B,C,G, & BW should be paste in book2 from book1

Note:- there is a possibility that after everyday's copy & pasting Book2 file size may get high, hence after pasting all data in Book 2 it should delete all empty column & Rows ones then save the file

request you to pls provide code which i can apply it in book2

[amy_d2]

Can somebody help me on this please