M
Matts
Hi
I need to get the number of entries (of a certain type) based on
date & staff name
The data is presented as
a. Dates (All dates in column 'a' in a row)
b. Staff Name (Matthew) which is chosen through a drop down
(both a & b one one worksheet.)
another worksheet has the actual data sorted by date,time,staff name,
activity (which i need to lookup)
The cell adjacent to the date cell shouold pull up the no of records based
on the staff name chosen.
I hope I've been clear enuf on the question.
Any help apreciated.
Thx, Matt
I need to get the number of entries (of a certain type) based on
date & staff name
The data is presented as
a. Dates (All dates in column 'a' in a row)
b. Staff Name (Matthew) which is chosen through a drop down
(both a & b one one worksheet.)
another worksheet has the actual data sorted by date,time,staff name,
activity (which i need to lookup)
The cell adjacent to the date cell shouold pull up the no of records based
on the staff name chosen.
I hope I've been clear enuf on the question.
Any help apreciated.
Thx, Matt