Desmond
Member
Registered: 7th Jun 00
Location: Rossington, South Yorkshire
User status: Offline
|
Right, I work in a payroll office and we get returns from all the sites that come on excel sreadsheets.
At the minute I have to manually input all the information onto a master sheet which is then turned into a CSV file and imported into the payroll system.
The returns are various values e.g. Normal time, time and half etc. The problem is employees are graded by number for unsocial hours were they get a percentage and the return spreadsheet doesnt have these on e.g. the master sheet has all the percentages on like 15%, 17%, 20%, and so on but the return sheet only has unsocial and when we manually input onto the master we have to put these into the corect colums depending on there grade.
Im pretty good on excel but am strugling on this but there must be a way of automatically copying the retun sheets onto the master and into the correct cells relevent to there grade.
Any help appreciated, if you dont understand the above I can send you the spreadsheets so you can see what I mean......
Any help apprciated
[Edited on 07-12-2004 by Desmond]
|
Jamie
Member
Registered: 1st Apr 02
Location: Aberdeen
User status: Offline
|
Thought you owned a bodyshop?
|
Desmond
Member
Registered: 7th Jun 00
Location: Rossington, South Yorkshire
User status: Offline
|
quote:
Originally posted by J-Me
Thought you owned a bodyshop?
Got shat on big time..... hense loosing about 15k's worth of car, and being another 5k out of pocket, but please dont post on this thread about that 
|
Matt H
Member
Registered: 11th Sep 01
Location: South Yorkshire
User status: Offline
|
He bummed the bodyshops pet goat & got sued for sexual harrassment 
|
