Hi

I have a massive table which has various departments in column C, services
supplied by the departments in column D and the period invoiced in column L.

When I sort by column C, D and L, I am able to calculate the Gross amount
that has been spent for the period by doing a basic SUM of Column Y.

What I want to achieve is to create some drop down options ( 3 drop down
cells) on a new work sheet that allow me to choose the value for column C,D &
L in 3 fields and for another cell to correctly go back to the previous
worksheet and to correctly sort and calculate the overall total value.

I'm not sure how to do this..... Can someone please give me assistance?

Thanks