How to automatic copy a row in a file to another file

samanbme - Nov 26, 2017 at 02:56 PM
I have a lot of excel files with sales project title that I fill a row in them every day, write my calling or visits reports. My manager also requested me to fill another excel file that is daily report. So I have to copy every row in any sales project file and paste it in a new row in the daily report file. So I want to know, is there a way to automatic copy the rows I add every day to sales project and be pasted automatically in a new row in my daily report file???