Calculation & Data transfer between worksheets | Excel forum

Resolved · High Priority · Version 2010

Wed 1 Mar 2017, 14:00 Delegate Hilary said...

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

Wed 1 Mar 2017, 14:10 Trainer Jens said...

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

Wed 1 Mar 2017, 16:25 Trainer Jens said...

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Paste with Live Preview in Excel 2010

Did you know you can preview what you are about to paste? Here's how to do it.

Copy what you are about to paste
Position the cursor where you want to paste
Right click to display the shortcut menu
Place the cursor over the Paste Options and this will give you a preview of the what you are about to paste.

View all Excel hints and tips