Combine 6 Worksheets to 1 Worksheet with total amounts

M

Ms. D

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

Total

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
 
M

Ms. D

Sorry, wrong info for Total worksheet

Total
and so on-->
Jan Feb
Jan Feb
Code Atlanta Atlanta
Chicago Chicago
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top