Subtotals

%3CLINGO-SUB%20id%3D%22lingo-sub-920452%22%20slang%3D%22en-US%22%3ESubtotals%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-920452%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%20with%20a%20list%20of%20payments%20to%20employees%20per%20month.%26nbsp%3B%20%26nbsp%3BI%20have%20added%20subtotals%20but%20now%20I%20want%20to%20have%20only%20the%20subtotal%20rows%20to%20reflect%20so%20that%20I%20can%20read%20it%20into%20another%20spreadsheet%20with%20VLOOKUP.%26nbsp%3B%20It%20will%20take%20forever%20to%20delete%20the%20other%20info%20and%20I%20will%20first%20need%20to%20copy%20and%20paste%20the%20subtotal%20rows%20as%20values....%26nbsp%3B%20please%20help%20!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-920452%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-920617%22%20slang%3D%22en-US%22%3ERe%3A%20Subtotals%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-920617%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F429595%22%20target%3D%22_blank%22%3E%40J9steyn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%3C%2FP%3E%3CP%3EI%20attached%20a%20sample%20file%20for%20you.%3C%2FP%3E%3CP%3EIn%20Sheet%201%20there%20is%20a%20list%20of%20Employees%20and%20their%20Payment%20with%20a%20Subtotal%20created%20for%20each%20employee.%3C%2FP%3E%3CP%3EIn%20Sheet%203%20I%20created%20a%20Drop%20List%20to%20select%20the%20Employee%20Name%20and%20a%20VLOOKUP%20function%20to%20pick%20up%20the%20Subtotal%20from%20Sheet%201%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DVLOOKUP(E1%26amp%3B%22%20Total%22%2CSheet1!%24A%241%3A%24C%2424%2C3%2C0)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EHope%20that%20Helps%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I have a spreadsheet with a list of payments to employees per month.   I have added subtotals but now I want to have only the subtotal rows to reflect so that I can read it into another spreadsheet with VLOOKUP.  It will take forever to delete the other info and I will first need to copy and paste the subtotal rows as values....  please help !

1 Reply
Highlighted

@J9steyn 

Hi

I attached a sample file for you.

In Sheet 1 there is a list of Employees and their Payment with a Subtotal created for each employee.

In Sheet 3 I created a Drop List to select the Employee Name and a VLOOKUP function to pick up the Subtotal from Sheet 1

=VLOOKUP(E1&" Total",Sheet1!$A$1:$C$24,3,0)

Hope that Helps

Nabil Mourad