I am trying to condense and summarize data imported into excel from an access database. This is a check register that I am summarizing for data extraction analysis.
My columns are vendor, desc., inv. date, check date, check no., and amount. The info from the data base may have multiple rows for a check number because it is listed by account number. I sorted the data by check number and have run data subtotal so I now have a total by check but can't figure out a way to (1) have the vendor, desc, etc. on the subtotal line without individually copying the information to the subtotal line and (2) extract the total line information to another worksheet for further data analyzis. I have tried pivot tables but that won't do what I need.