Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Table Combination with Sorting
I have a workbook with two sheets with customer names and receivable balances
from two different divisions (the customer names and balances change daily). Some of the customers are the same on both sheets. I would like to create a third sheet that will list all of receivable balances from both sheets and combine the balances of any customers that are the same in both sheets and then have the balances sorted from highest to lowest. The result in the third sheet will be linked to another report. I currently do this manually - is there a better way using functions? Would pivot tables work? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Table sorting and v look up possible & | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Pivot Table Sorting | Excel Discussion (Misc queries) | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
Problems with sorting a pivot table | Excel Discussion (Misc queries) |