Auto Populate remaining columns

Visitor

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