Excel record into word document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rachel Curran - 26 May 2004 09:42 GMT

> I have an excel spreadsheet which contains employee
> records - I want to be able to view and print individual
> records but only the fields that are populated for example:
>
> Excel:
>
> Emp No Name DOB Department Grade
> 12345 Joe 28/02/78 Finance
> 67890 Ian E5
> 11122 24/11/81 HR
>
> I want to be able to print and view these records separately ie:
>
> Emp No 12345
> Name Joe
> DOB 28/02/78
> Department Finance

Reply to this Message

Charlie - 26 May 2004 16:33 GMT

Rachel,

If the header is in row one then go to View/Header
Footer/Sheet. In the 'Rows to repeat at top" enter 1:1
and click OK. Now select the row to print and go to
File/Print and check Selection. When you print the Header
will print along with the selected row.

Hope this helps.

Charlie O'Neill

>-----Original Message-----
>> I have an excel spreadsheet which contains employee
[quoted text clipped - 15 lines]
>> Department Finance
>.

Reply to this Message

Mark E. Philpot - 27 May 2004 06:27 GMT

You will require a macro for this job. It needs to find
the field which is not empty or blank then refer to the
header for its title.

When the last title has been determined for that employee,
insert a page break.

If I have determined the requirements correctly, maybe you
could send me a dummy sheet (up to 1 mb) so I could write
something for you. You can view some of my handiwork at:
http://au.geocities.com/excelmarksway

regards
Mark E. Philpot

>-----Original Message-----
>Rachel,
[quoted text clipped - 32 lines]
>>
>.

Reply to this Message