Hello,
New to the website. I am seeking help with a formula. I have staff using same excel worksheet for 3 shifts. I need the stats from each individual worksheet for specific day and shift to populate on a monthly report for each shift. Currently have someone that manually enters the data into each shift on the monthly report. The worksheets have staff member's name and shift on one sheet of worksheet and the other sheets have totals for specific work performed and another sheet that they fill in all necessary information such as person's name, identifier number, current location and location being relocated to, and if put on all particular status.
Any assistance would be appreciated.
New to the website. I am seeking help with a formula. I have staff using same excel worksheet for 3 shifts. I need the stats from each individual worksheet for specific day and shift to populate on a monthly report for each shift. Currently have someone that manually enters the data into each shift on the monthly report. The worksheets have staff member's name and shift on one sheet of worksheet and the other sheets have totals for specific work performed and another sheet that they fill in all necessary information such as person's name, identifier number, current location and location being relocated to, and if put on all particular status.
Any assistance would be appreciated.