Seeking 1 hour of excel 2010 report consultant time - at your earliest convenience

[BobT515]

I need to create 3 or 4 detailed reports from an excel 2010 worksheet.

My worksheet contains data including date, invoice number, company , consultant, days, dollars
There are approximately 100 records in the worksheet

Requirement 1 :I want to use excel 2010 to automatically generate a series of reports
broken down by consultant
showing date, invoice number, company, and consultant
with totals for days and dollars

when all the records for consultant 1 are listed , then i want to show consultant 2

same for any other consultants


with a grand total at the end



My understanding is that excel 2010 makes this process very simple

Can someone show me an example of how to do this PLEASE

Need to generate this report today - if at all possible

No response earlier . Is there a senior consultant willing to consult for 1 hour on this project for a fee?????
Please advise Please help . we are a startup and this is an opportunity to expand our practice .

Thanks Bob T

[GC Excel]

Have you tried using Pivot table?
See example attached in sheet "Feuil1" from the data in sheet "All consultants..."

Let me know if this is what you are looking for.

[BobT515]

Yes I want to use the pivot table approach.

Need to find someone with lots of expertise in Pivot to get this set of reports done quickly.

Please email me at [email protected] to discuss....
if interested and qualified.

BobT

PS I could not see the file you refereced Please resend directly to my email

Thanks

[GC Excel]

Just sent you an email...