Create a report in excel

[Chrys]

Dear all,

Could somenone help me on how can I create & print a report for each
case that will have all or only selected variables from each case?


To be more specific. I have a database which is anthropometric
measurements of a sample and I would like to create a feedback report
to be mailed in each case-person. So in every separate page the name
of that person should be at the top and the results of the
measurements below- each measurement result in a different row.


Many thanks in advance!

 

[Earl Kiosterud]

Chrys,

I don't think there's a very direct way to do that with Excel. Data - Subtotals using page
breaks would get you part of the way there. There's a similar post from a few days ago
where I suggested either using Word's Mail Merge against the Excel data, along with come
macro help in Word, or using Access (also against the Excel data, if that's where it
currently lives).