Experience Level: Intermediate
I\'m pulling together a spreadsheet to deal with payroll in a medium sized company. Some are paid weekly, some monthly, some per hour, some per month. My spreadsheet needs forumulas (IF and VLOOKUPs) to read from one tab to another and it needs automating as much as possible. I\'m looking for someone to do this and perhaps suggest a better organisation of the spreadsheet if necessary. I\'d like it to have a reporting function (pivot tables?) so I can filter information and run a report on certain things. Things like the overtime rate etc needs to link up to the lookups tab.
There are no clarification messages.