both files are loacted in same place
vba is placed in d.xlsm
another file name is sample2.xlsx
open sample2.xlsx
clear the contents of column A,column B,column C,column D,column E,column F,column G,column H,column M,column N,column P,column Q, sample2.xlsx by vba
and save and close the sample2.xlsx after clearing the content
Pz help me in solving this problem sir by vba macro