Hi

You're very welcome and thanks for the feedback to let us know it sorted
your problem.

--
Regards

Roger Govier


"kdmarvin via OfficeKB.com" <u32449@uwe wrote in message
news:6f2d1c2891fbd@uwe...
Roger,

By Golly it works. I had been going in the wrong direction all the
time.
Thank you so much for setting me straight. And thanks to all the folks
here
for the great help.Us 'Newbies' really do need you.

Kirk

Roger Govier wrote:
Hi

Forget about the 45 extra sheets.
Add one extra column to Sheet1 headed Date
Put the relevant month date in this column as you enter each
successive
line , including the relevant Building name on each line.

Mark the header row, DataFilterAutofilter
use the dropdown on Building name to select any building, and you will
see all results for that building alone.

Sheet 1 is a list of buildings (approx. 45). There are 2 fire
extinguishers
[quoted text clipped - 82 lines]
in this
month yet not change the month before?

--
Message posted via http://www.officekb.com