Forum Discussion
Excel Help
It would help if you attached a copy of the workbook.
HansVogelaar Hello, sorry I've attached it here... I wasn't sure what was best to do...
See the attached version (now a macro-enabled workbook, so you'll have to allow macros when you open it).
To view the code, right-click the sheet tab of the Rota sheet and select View Code from the context menu.
Can you explain how hours should be calculated?
HansVogelaar ahh Macros! Makes sense now! Thank you!
Hours is still the bit I am trying to figure out... What I want to do is if for example someone is rotared in for a stage shift then their hours are 5.5hours and it automatically inserts that into the time sheet
You'd have to create a table on the same sheet or another sheet in the same workbook that lists the hours for each type of shift.
In the attached version, I have created such a table, with random hours, on Sheet3. I named it Hours. You should edit it as needed.
The TimeSheet1 sheet uses VLOOKUP to return the hours corresponding to the shift types selected on the Rota sheet.