Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
extract data after sort
I have exported a check register from an access data base into 319 page excel
spreadsheet. The data is arranged: vendor, desc. inv. date., check date, check no. and amount. I am trying to summarize and extract check totals from this. The data base listed amounts by account so I sorted all the data and ran subtotal to get the total amount for each check. I can hide the desc. & inv. date if necessary because they aren't relevant to what I am trying to accomplish. Now I would like to (1) get the vendor name and check date to copy? to the subtotal row so that I have a single row showing vendor name, check date, check number and amount and (2) extract the that line of data to a separate worksheet to run some secondary sorting. I have tried pivot tables but that has not worked. Any suggestions would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
extract and sort dates | Excel Discussion (Misc queries) | |||
Pls. reply Sort Data and copy to next coulmn when sort order chang | Excel Programming | |||
Sort Data and copy to next coulmn when sort data changes | Excel Programming | |||
Sort Data and copy to next coulmn when sort data changes | Excel Programming | |||
How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) |