Creation of Contractor Slip

%3CLINGO-SUB%20id%3D%22lingo-sub-1364677%22%20slang%3D%22en-US%22%3ECreation%20of%20Contractor%20Slip%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1364677%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20I%20am%20trying%20to%20create%20a%20wage%20slip%20for%20self%20employed%20contractors%20and%20am%20struggling%20to%20get%20the%20relevant%20information%20required%20onto%20the%20slip.%3C%2FP%3E%3CP%3EI%20am%20creating%20a%20table%20with%20all%20their%20basic%20information%20then%20in%20the%20next%20tab%20it%20calculates%20hours%2C%20deductions%20and%20so%20on%2C%20i%20am%20looking%20to%20pull%20all%20this%20information%20through%20onto%20a%20wage%20slip%20template%20so%20as%20the%20numbers%20grow%20all%20i%20need%20to%20do%20is%20add%20the%20basic%20information%20and%20the%20hours%20and%20it%20will%20automatically%20generate%20this%20information.%3C%2FP%3E%3CP%3EShould%20i%20use%20a%20standard%20table%20and%20then%20the%20lookup%20function%20or%20would%20a%20pivot%20table%20be%20more%20useful%20as%20this%20grows%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1364677%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1364791%22%20slang%3D%22en-US%22%3ERe%3A%20Creation%20of%20Contractor%20Slip%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1364791%22%20slang%3D%22en-US%22%3EA%20table%20and%20lookup%20function%20should%20be%20able%20to%20solve%20the%20problem.%3C%2FLINGO-BODY%3E
New Contributor

Hi,

      I am trying to create a wage slip for self employed contractors and am struggling to get the relevant information required onto the slip.

I am creating a table with all their basic information then in the next tab it calculates hours, deductions and so on, i am looking to pull all this information through onto a wage slip template so as the numbers grow all i need to do is add the basic information and the hours and it will automatically generate this information.

Should i use a standard table and then the lookup function or would a pivot table be more useful as this grows

1 Reply
A table and lookup function should be able to solve the problem.