Combine 6 Worksheets to 1 Worksheet with total amounts
 

Sorry, wrong info for Total worksheet

Total
and so on--
Jan Feb
Jan Feb
Code Atlanta Atlanta
Chicago Chicago
300 - Bill Expense 359.23 359.23 234.23
301 - Process Fee 65.00 45.00 45.00
302 - Sales 3333 4444
400 - Bill Expense 4560.00 4560.00 333.22


"Ms. D" wrote:

I have 6 worksheets from Jan, Feb, Ma,r Apr, May, Jun that have different
information on each worksheets. And would like to have another worksheet that
would combine all the different codes (over @120 lines) with the appropriate
dollar amount for each city. For Example

Jan

Code Atlanta Chicago Detroit
300 - Bill Expense 359.23 234.23 1132.32
301 - Process Fee 65.00 45.00 50.00
400 - Bill Expense 4560.00 333.22 232.32

Feb

Code Atlanta Chicago Detroit
300 - Bill Expense 359.23 234.23 1132.32
301 - Process Fee 65.00 45.00 50.00
302 - Sales 3333 4444 5555
400 - Bill Expense 4560.00 333.22 232.32

and so on

Combine 6 Worksheets to 1 Worksheet with total amounts
 

Pivot Table with
Consolidate Ranges,
Page as Column
http://www.savefile.com/files/1683348