Counting Various Things
 

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.

Counting Various Things
 

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.

Counting Various Things
 

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