I have a workbook called tracker that adds new records from a workbook called
data. When I add a new record I want to copy the formulas and formatting from
the row above and paste them into the empty row. Every time I try it copies
the values as well. please help