Here is my situation
I have productivity sheet that employees fill out through out the night. At the end of the night the sheet gives them the total hours they worked and gives them the total files they completed. These two pieces of data are then typed into a table connected to a separate workbook so that all the agents numbers are in a bigger table for further calculations
i would like to add a End shift macro that they click at the end of the day that copies those two pieces of data and puts them in the table based on a date
the date range on the table is 1/1/2018 to 12/31/18 and the date on their productivity sheet is set to today()
I have productivity sheet that employees fill out through out the night. At the end of the night the sheet gives them the total hours they worked and gives them the total files they completed. These two pieces of data are then typed into a table connected to a separate workbook so that all the agents numbers are in a bigger table for further calculations
i would like to add a End shift macro that they click at the end of the day that copies those two pieces of data and puts them in the table based on a date
the date range on the table is 1/1/2018 to 12/31/18 and the date on their productivity sheet is set to today()
