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