Payroll workbooks for multiple locations

%3CLINGO-SUB%20id%3D%22lingo-sub-3375350%22%20slang%3D%22en-US%22%3EPayroll%20workbooks%20for%20multiple%20locations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3375350%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20a%20workbook%20that%20will%20have%20the%20first%20worksheet%20as%20the%20parent%20document%20where%20all%20the%20necessary%20information%20would%20be%20added%2C%20This%20information%20can%20total%20approximately%20300%20lines%20every%205%20days.%3B%3C%2FP%3E%3COL%3E%3CLI%3EName%3C%2FLI%3E%3CLI%3ELocations%3C%2FLI%3E%3CLI%3EHours%20worked%20(1st%20-%20end%20of%20month)%3C%2FLI%3E%3C%2FOL%3E%3CP%3EI%20need%20to%20find%20a%20formula%20that%20would%20search%20Column%20A%20(Name)%20for%20specific%20names%20and%20then%20pull%20all%20the%20information%20in%20that%20row%20and%20put%20it%20in%20a%20separate%20worksheet%20created%20for%20each%20specific%20person.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3375350%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3375377%22%20slang%3D%22en-US%22%3ERe%3A%20Payroll%20workbooks%20for%20multiple%20locations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3375377%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1390250%22%20target%3D%22_blank%22%3E%40Gregory_Farnum%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20see%20attached%20workbook.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am trying to create a workbook that will have the first worksheet as the parent document where all the necessary information would be added, This information can total approximately 300 lines every 5 days.;

  1. Name
  2. Locations
  3. Hours worked (1st - end of month)

I need to find a formula that would search Column A (Name) for specific names and then pull all the information in that row and put it in a separate worksheet created for each specific person.

 

1 Reply

@Gregory_Farnum 

Please see attached workbook.