I've got 6 worksheets (one for each workstation) in a workbook all
with various data (user who made entry, date entered, entered am/pm,
week entered, entry type, month entered, etc.) How can I set up
worksheet 7 so that I can count different things - eg number of
entries made by user A in the afternoons, number of entries of type B
made by user C at workstation D in April, total number of entries at
workstation E, etc, etc. I've tried a pivot table but can't get on
with it.

Hi,

It would help to share the workbook in which you have this information. You
may mail the workbook to me at .

--
Regards,

Ashish Mathur
www.ashishmathur.com

"robzrob" wrote in message
...
I've got 6 worksheets (one for each workstation) in a workbook all
with various data (user who made entry, date entered, entered am/pm,
week entered, entry type, month entered, etc.) How can I set up
worksheet 7 so that I can count different things - eg number of
entries made by user A in the afternoons, number of entries of type B
made by user C at workstation D in April, total number of entries at
workstation E, etc, etc. I've tried a pivot table but can't get on
with it.

Using Pivot Table,
Lists and VBA
http://www.freefilehosting.net/download/3g186