Hi all,
We have standalone rota system for staff, this produces a weekly roster of all staff in a HTML document.
The information is shown in a table form whereby each staff member has their own row broken down into the seven days, each day contains 4 columns showing start time, finish time, shift length, and rostered job.
I used to be able to copy this directly onto an excel spreadsheet when the company was using excel 97-03, the company have recently updated excel, now when I copy the HTML sheet to excel all of each staff members info for the week is shown in one cell.
Is there a setting that requires adjusting in my excel worksheet or will this not work at all on recent versions of excel?
I hope someone can answer this for me.
Many thanks in advance
J
We have standalone rota system for staff, this produces a weekly roster of all staff in a HTML document.
The information is shown in a table form whereby each staff member has their own row broken down into the seven days, each day contains 4 columns showing start time, finish time, shift length, and rostered job.
I used to be able to copy this directly onto an excel spreadsheet when the company was using excel 97-03, the company have recently updated excel, now when I copy the HTML sheet to excel all of each staff members info for the week is shown in one cell.
Is there a setting that requires adjusting in my excel worksheet or will this not work at all on recent versions of excel?
I hope someone can answer this for me.
Many thanks in advance
J