PC Review


Reply
Thread Tools Rate Thread

Create a report in excel

 
 
Chrys
Guest
Posts: n/a
 
      10th Feb 2007
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!

 
Reply With Quote
 
 
 
 
Earl Kiosterud
Guest
Posts: n/a
 
      11th Feb 2007
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!
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
create a report tool from Excel =?Utf-8?B?SmFuaXM=?= Microsoft Access 0 13th Sep 2007 04:46 PM
How do I create a Tickler report using MS Excel? =?Utf-8?B?UmljaGFyZENyZWQ=?= Microsoft Excel Misc 0 12th Feb 2007 09:23 PM
create report in excel sheet =?Utf-8?B?QXNrRXhjZWw=?= Microsoft Excel Worksheet Functions 3 8th Jul 2006 07:07 PM
Create Access like report in Excel. =?Utf-8?B?Si1TaGVybS1Ed3llcg==?= Microsoft Excel Programming 1 17th Feb 2005 08:21 PM
How do I create a running report on Excel =?Utf-8?B?TWljaGVsbGxlIE0=?= Microsoft Excel New Users 1 16th Jan 2005 02:54 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:36 AM.