I am relatively new at this but here goes...

I am trying to create a macro to tell me how many times a seat has been
occupied since it was last checked.

i.e. seat 1 checked on 3.13.07

column A column b
seat number check date
1 3.13.07

I have a separate data report which identifies on a per day basis how many
times the chair was used. i.e.

date 03.01.07 03.02.07 03.03.07........
chair number
1
2
3
......

I need to qualify how many times (not the last time) the chair was used
since the last date it was checked.

ANY SUGGESTIONS?
I am really lost here.....