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).
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Chrys" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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!
>