breifcase78

New Member
Joined
Apr 12, 2010
Messages
2
I need to summarize data from 4 sheets in a workbook into one master sheet within the same workbook. The 4 sheets represent different employees and the data are the accounts they are responsible for spread over 12 months. There's a billed, paid and difference row. The summary sheet needs to have all the accounts and all the employees.
Is there a formula way to do this?
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
Instead of 4 sheets put all into one table with an "Employee" column.
Can then use filters, pivot tables etc. from the Data menu.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,877
Messages
5,574,770
Members
412,617
Latest member
mlharris
Top