Subtotals

[J9steyn]

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 !

[#2]

@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