Hello,
I have an monthly expenses workbook with the 12 months, Jan-Dec for each employee. Employee completes his/her expense report each month. I'm trying to copy the totals from each month into a summary sheet which has columns for each of the 12 months. Other than creating a formula in each of the cells in the Summary sheet . How would I accomplish this copy/past task?
Thank you.
Note: The Summary sheet is within each Employee's 12-month workbook.
I have an monthly expenses workbook with the 12 months, Jan-Dec for each employee. Employee completes his/her expense report each month. I'm trying to copy the totals from each month into a summary sheet which has columns for each of the 12 months. Other than creating a formula in each of the cells in the Summary sheet . How would I accomplish this copy/past task?
Thank you.
Note: The Summary sheet is within each Employee's 12-month workbook.