To clarify to your first question. When copying the range (which includes the formulas) from the prior day's sales data (in a seperate workbook file) and pasting to the new day's sales data sheet, it only pastes data from the prior days workbook and does not copy the formulas.
The paste...
I receive a daily sales report which is formatted the same way each day. From one day to the next I copy a block of cells with formulas from the prior day to the current day. Up until this week, this operation had worked just fine. Now instead of copying the formulas, it copies only the data...