Filter Area

[musicmike]

I am trying to create a workbook to calculate sickness records where
want to see on a daily basis each person’s instances and total day
sickness.
I have a list which consists of a column for date the a column fo
each person.
I have created formulas to calculate the same date as today 6 month
ago and an advanced filter to only show records that are newer tha
that date.

My problem is defining the area to use the filter on, as new rows wil
be added daily.

I’m sure there is a simple answer to this but I can’t figure it out.

Grateful for any help on this

 

[DDM]

Musicmike, take a look at creating dynamic ranges here:
http://www.contextures.com/xlNames01.html#Dynamic. Note that by assigning a
name to a formula using the OFFSET worksheet function, you'll be able to
define a filter area that automatically grows as you add data.