Question: how do i automatically copy a row in excel to another sheet?
Answer: Right click on the tab of the sheet you want to copy , click move or copy then click the copy box, past to where you want it to go in the current workbook, another open workbook or a new workbook. In same workbook control + drag on the tab drag to left or right. Open Excel Sheet an save it with a new name.