Hi
I look for macro to copy ranges from first file G2:I and B2:D from second file to file master into range B2:D and the column A should autonumbering 1,2... based on filled data from B2:D in file master and should overwrite every time run the macro . the file1 is xlsx and file2 is xlsm and file master where run the macro from it is xlsm .
two files are existed folder name is REPORT . so should open Dialog box and select folder and pull data without select files and open
thanks in advance
I look for macro to copy ranges from first file G2:I and B2:D from second file to file master into range B2:D and the column A should autonumbering 1,2... based on filled data from B2:D in file master and should overwrite every time run the macro . the file1 is xlsx and file2 is xlsm and file master where run the macro from it is xlsm .
two files are existed folder name is REPORT . so should open Dialog box and select folder and pull data without select files and open
thanks in advance
Last edited: