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
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
