Omitting A Row From Autofilter

S

SamuelT

Hi all,

I have a list of various billable items to be billed over a range o
months. People want to see exactly what we are billing per month. T
get the items being billed in a single month I am using the Autofilte
function. However, the problem with this is that it also filters th
final row of my table that displays what the monthly total is.

Is there a means of applying the autofilter but also specifying a ro
that should not be filtered out (i.e. the total).

Any assistance much appreciated,

TIA,

Samuel
 
Top