I have two excel sheet in D:/sheet1.xls, D:/sheet2.xls. I want to copy the data from second row of sheet 1 and 2 to a new sheet (D:/sheet3.xls) to the last row where data is empty
if sheet 3 contain 200 records, then the output of sheet 1 start from 201 records upto last, followed by sheet2 data.
I am new, Can anybody help me in writing the macro.