Hello,
So this is my first time posting on this forum, as I have reached a point where I have absolutely no idea what to do with my spreadsheet to get what I want. I hope that someone will be able to help me. (please let me know if I don't explain my problem well.)
Alright, so I am creating a workbook that has multiple tabs for each individual project and then bring in the total salaried cost to a consolidated tab. For each project we have different rates that we charge per employee and this differs per project ( I have these rates in a column that is multiplied by the amount of hours to determine total salaried cost). I have created a vlookup to bring in the amount of hours worked per project. (this was from a pivot table that has projects and person, with hours as the value). The problem I have ran into is the fact that the employees pay rates have changed over the past 3-4 years, (all employees pay rates change about every 6 months.) Is there a way that I can still vlookup the amount of hours however separate it out by date and then multiply by the rates I have? Currently I do have a data file that I create the pivot table from and it does have all the data necessary, employee name, project number and dates. Currently the dates aren't in the pivot table. Is there anyway to bring in the dates to the pivot table and split the hours based on a selected date range from this? What would the pivot table have to be and what would the formula be? Or is there a better way to do this? Any help would be greatly appreciated!!!
Bookmarks