Was hoping someone here could help me out with a commandbutton that would copy data from one workbook1 sheet to a separate workbook2 sheet starting from A16:G16 on down. But copy in a way that it copies over data over were it doesn't overwrite the old data and also doesn't copy over duplicate row entries. I have a workbook1 I have multiple tabs with all employees names. And in workbook2, they only have a tab with there name to enter data. So when they finish updating there info and they click the button it will automatically copy the new data over to worksheet1 in the correct worksheet name. Is this possible?