Pivot Table help

9

95helsby

New Member
Joined
Jul 30, 2009
Messages
13
Hi,

What I need is seems like it should be easy but I can't figure it out so I'm hoping someone with more knowledge can.

I have 10 workbooks, 1 of each employee. Each workbook has one sheet for each month of the year. the table for each month is really simple; just date is the 1st column and deal name in the 2nd column.

What i need is to produce a pivot table on a seperate workbook showing how many deals have been dealt with by each person on each day and each month. Easy right??

I hope this makes sense, thanks in advance for your help.

Mark
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
You must log in or register to reply here.

Similar threads

rjbinney
  • Question Question
Columns by Month in Pivot Table
2
Replies
17
Views
831
Alex Blakenburg
A
S
  • Question Question
Filter in Pivot Table Field List Clearing when The Pivot Table Is Refreshed
Replies
1
Views
611
arun_eagertolearn
A
Y
  • Question Question
Pivot Table deletes on opening of workbook
Replies
3
Views
231
cooleomter
C
J
  • Question Question
How can I copy the grouping rules from one pivot table to another pivot table?
Replies
0
Views
298
jaza_tom
J
J
  • Question Question
Pivot table from 2 tables not "filtering" as expected
Replies
0
Views
253
jorgemarmo
J

Forum statistics

Threads
1,223,903
Messages
6,175,289
Members
452,631
Latest member
a_potato

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top