Thread: Charting Payroll

They should all be like 004-12. The clerical one is the only one that is a little different. What should I do next?

Hi

Have you amended all your sheets to be the same structure as 004-12? If so, then adjust the macro to reflect that you are extracting data from column 67 rather than column 60 and see how it goes.

rylo

Ok I ran it. I deleted the clerical worksheet which I will add later as a regular sheet. Only one issue here. Check job sheet 012-12. The employee worked 10 hours on Saturday which should have transfered to the input sheet as 11J OT and then the payroll report as 10 hours OT in dept 11J. It did everything it should but showed 0 hours. Maybe a simple fix. Im not sure. Can you take a look at the attachment.

Hi

The overtime hours should be coming from column 68, not column 61.

rylo

Hi thank you. I ran that and I believe there was a glitch. Please run it. You will see what I am talking about.

Opened file, ran macro bbb, program ran to completion with no errors.

Can you be more specific on the "glitch".

rylo

ok run this. You will see brian and kevin's hours in 1 department but they are split when they shouldnt be. Same dept.

so you are now saying that when the hours are transferred over to the payroll report sheet, if there are already any existing hours for a particular department for that employee, then any new hours should be added to the existing hours, not appended to the right? If so, then this hasn't been mentioned before that I can recall or find in any post.

rylo

No that is not the case. There is just a glitch. Those 2 particular employees hours get screwed up. If you run it you will see the error.