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