Auto Populate remaining columns

%3CLINGO-SUB%20id%3D%22lingo-sub-2921768%22%20slang%3D%22en-US%22%3EAuto%20Populate%20remaining%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2921768%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20auto-populate%20remaining%20columns%20(in%20same%20row)%20based%20on%20value%20in%20one%20column%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20thousands%20of%20.pdf%20pages%20to%20enter%20into%20a%20worksheet%20from%20payroll.%20I%20need%20to%20enter%20%3CU%3Eemployee%20name%2C%20SSN%2C%20job%20class%2C%3C%2FU%3E%20hours%20worked%2C%20%3CU%3Ewage%20rate%3C%2FU%3E%2C%20week%20ending%2C%20and%20project%20name.%20The%20%3CU%3Ename%2C%20SSN%2C%20job%20class%20and%20wage%20rate%3C%2FU%3E%20remains%20the%20same.%20Is%20there%20a%20way%20for%20me%20to%20just%20enter%20or%20select%20the%20name%20and%20have%20the%20remaining%20columns%20listing%20SSN%2C%20Job%20Class%2C%20and%20wage%20rate%20automatically%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20attached%20sample%20payroll%20and%20worksheet%20layout%20template.%26nbsp%3B%20I%20have%20MS%20360%20Excel%202018%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2921768%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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