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
