| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combine 6 Worksheets to 1 Worksheet with total amounts
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine 6 worksheets into 1 worksheet - Summary | Excel Discussion (Misc queries) | |||
| How to automatically combine several worksheets into on ene worksheet | Excel Discussion (Misc queries) | |||
| Total Dollar Amounts From Different Worksheet | Excel Worksheet Functions | |||
| How do I combine multiple worksheets into one worksheet? | Excel Worksheet Functions | |||
| combine different worksheets to a single worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
