I think I am in need of a Macro for this?

[RandyMac]

I have three sheets and a summary sheet. Each sheet contains data fo
different departments. On the summary page I need to break ou
information by supervisor then I need it to return a count total of
spacific column. For instance: If I have two supervisors I want t
pull data for each that show how many part time(PT) and How Man
Full-time(FT) they have.
I thought I may have to have a macro to have it sort the sheet b
supervisor then an countif statement to count PT and FT and so on.
Maybe just an nested if statement would work. I am not sure what woul
be eaiser.

Can someone help?


Thank

 

[JE McGimpsey]

I'm having trouble envisioning your data, but it sounds like a Pivot
Table might work for you...

 

[Frank Kabel]

Hi
I agree with JE, also having problems envisiong the data strcuture of
your workbook. For pivot tables some starting information:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm

If they're not what you want you may post some example data rows (plain
text - no attachments please) to this NG and explain your expected
results based on this example data

 

[Ken Wright]

And oh by the way, if you create a single summary sheet with the data from all 3
individual sheets on it under the same headings, you will find it a lot easier
to create a Pivot table with your data.