Auto Populate remaining columns


How do I auto-populate remaining columns (in same row) based on value in one column?


I have thousands of .pdf pages to enter into a worksheet from payroll. I need to enter employee name, SSN, job class, hours worked, wage rate, week ending, and project name. The name, SSN, job class and wage rate remains the same. Is there a way for me to just enter or select the name and have the remaining columns listing SSN, Job Class, and wage rate automatically? 


I attached sample payroll and worksheet layout template.  I have MS 360 Excel 2018

0 Replies