I have been banging my head against the wall trying to figure out this one. Any help would be great.
I have an Excel 2013 workbook with multiple sheets in it. There is a MASTER page and multiple subordinate pages. This workbook is used to calculate employee commission and in turn place all the data on one sheet so it can be turned into the accountant. I have tried using VLOOKUP as well as 4 or 5 other options. None have produced what I am trying to achieve. Perhaps I am wanting something not possible. Here is a screen shot of the 2 pages. Below I will outline how they work and what I need.
Each employee will have their own sheet that will track their sales and the commission they get. On the sheet I only have 4 areas that are not locked, those are depicted with green cells. So the boss only needs to type the info in and it will calculate. This sheet is functioning fine.
On the master I have created a Data Validation drop down box to pull the payroll dates from the second sheet in column B. This is set as Check_Date
I am trying to select the check date from the drop down and have the data from the subordinate sheet pulled into the master. The only 2 pieces I need are PAYABLE and CASH TIPS. The number would come from the row that corresponds to the date in the drop down. This info needs to be pulled from each sheet that corresponds to a user on the master page
I am not sure if I need to add an index column to make this work or what.
Any help or suggestions are very much appreciated.