Hilary has attended:
Taking Minutes course
Calculation & Data transfer between worksheets
Good afternoon,
I have inherited an excel workbook that calculates OT hours and amounts to be paid for each employee in the department.
However, I have a couple of lines in Worksheet 'Summary' which are not bringing in the data correctly from the front page.
Line 33 Aaron Ghatt Has worked 24 hours OT but I am unable to get the sheet to recognise this.
Line 31 Richard Tracey - Has carried out step up shifts but this is missing a shift. Even when I add another line on the Input sheet it still doesn't recognise it.
To bring data from Input sheet into 'Summary' sheet I select the data in Tab 1 and then right click on an empty cell in Tab 2, Right click and press Refresh. It then brings in the daily entries into a monthly overview for each employee.
Once I have this and validated it, I return to Tab 1 and press 'Export OT sheet' and this takes the data into the correct format for our payroll department to manage.
Please can you help me with the lines x 2 which are not calculating correctly.
Many thanks
Hilary
RE: Calculation & Data transfer between worksheets
Hi Hilary,
Thank you for the forum question.
I will need to have a look at you Excel file to help you.
Please send it to:
info@stl-training.co.uk
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Calculation & Data transfer between worksheets
Hi Hilary,
A lot of things are going on in this workbook. Macros, PivotTable and some complicated nested functions.
I cannot see you have a problem with Aaron. The pivottable on the summary sheet show the information from the Input sheet.
If you unhide column M on the Input sheet, you will see that one of the formulas is missing for Richard. Copy the formula down. You will also need this if you add more records at the bottom.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
