I want any VBA code or formula which copy only certain cells into summary work book.
For Example I create new file every week and name as "DPR 06-30-12" or whatever is week end for that month, I want to copy Total from total sheet into YTD summary sheet, whenever the weekly file created and uptdate the value daily basis automatically whenever the data enter in the weekly file, any help will be appreciated greatly.
For Example I create new file every week and name as "DPR 06-30-12" or whatever is week end for that month, I want to copy Total from total sheet into YTD summary sheet, whenever the weekly file created and uptdate the value daily basis automatically whenever the data enter in the weekly file, any help will be appreciated greatly.
