M
Michael Korman
I am trying to make a report in Excel from data that
was taken from a database. I have two worksheets. The
first contains my raw data, which is in the form of
one row per record. The second is my report. In the
report, I would like to have multiple rows for each
record, so that I can conserve horizontal space. There
are two things I would like to do:
1) Sort my records by some field.
2) Autofill all of my records down the whole worksheet.
Both of these are hard to do because I want to use 3 lines
for each item, instead of one. If I fill in the references
to the raw data worksheet for the first item, and then
drag, it fails because it thinks each row is its own item.
Same problem with sorting.
How do I get around this?
was taken from a database. I have two worksheets. The
first contains my raw data, which is in the form of
one row per record. The second is my report. In the
report, I would like to have multiple rows for each
record, so that I can conserve horizontal space. There
are two things I would like to do:
1) Sort my records by some field.
2) Autofill all of my records down the whole worksheet.
Both of these are hard to do because I want to use 3 lines
for each item, instead of one. If I fill in the references
to the raw data worksheet for the first item, and then
drag, it fails because it thinks each row is its own item.
Same problem with sorting.
How do I get around this?