This is a continued session. I need help with the PTO Report tab. The template I used only shows the employees data for one employee at a time from the drop down menu. I need to have access to all of the employee's PTO balances at one, for calculation purposes. Although I do want to keep this tab as is, I need to create either another tab, multiple tabs, or as a column added to the end to the Employee PTO Data tab. with the total available PTO for each. I need the data from the PTO Report tab AJ6 to appear in the Employee PTO DATA tab down the G column for each employee on the drop down menu on the PTO Report tab. I also need a new column in the H column on the Employee Data page to automatically fill with each employees information from the AL30 on the PTO Report tab. I basically need a listing of all of the Employee current PTO balances. And I will also need a listing of all the PTO hours used which overtime will appear on AL30, but will show as 0 for now. Need Pivot tables.
Solved by T. C. in 20 mins