creating a table automatically

[robnw11]

hi this is my first post, i'm fairly new to excel & i was hoping someone could help me out.
i'm doing some computer work for my uncle & as i was going through everything that needed doing & i came accross this excel problem. I'd already created the document which is an operational status report. when he asked me to set it up so that a section of the report would automatically appear on each new page of the document. he's given me a list of the cells he wants to appear automatically. the list is a box from the cell A8 down to the cell N17.
within the box is at least one table.

is it possible to do this & if so how do i do it?

thanks in advance & i'd appreciate quick responses

[protonLeah]

1. Select the cells in Excel spreadsheet you desire to insert and copy.
2. In your report, place the cursor where you want the table,
   Select: Edit-->Paste Special
   At the Paste Special dialog, select the "Paste Link" radio button, select MS Excel WS Obj from the "As:" list
3. O.K.

[Otto Moehrbach]

When you say "new page of the document" do you mean each new page as the
paper pages are printed? Or do mean to say "new sheet"?
If you mean that you want every new sheet to have that block of data,
simply create one sheet with that data, then use that sheet as only a
template sheet. When you want to create a new sheet, just copy that
template sheet then name it as you wish. HTH Otto
"robnw11" <[email protected]> wrote in
message news:[email protected]...
>
> hi this is my first post, i'm fairly new to excel & i was hoping someone
> could help me out.
> i'm doing some computer work for my uncle & as i was going through
> everything that needed doing & i came accross this excel problem. I'd
> already created the document which is an operational status report.
> when he asked me to set it up so that a section of the report would
> automatically appear on each new page of the document. he's given me a
> list of the cells he wants to appear automatically. the list is a box
> from the cell A8 down to the cell N17.
> within the box is at least one table.
>
> is it possible to do this & if so how do i do it?
>
> thanks in advance & i'd appreciate quick responses
>
>
> --
> robnw11
> ------------------------------------------------------------------------
> robnw11's Profile:
> http://www.excelforum.com/member.php...o&userid=36339
> View this thread: http://www.excelforum.com/showthread...hreadid=561283
>

[robnw11]

thanks a lot to both of you, i'll try the advice out now.

[robnw11]

in reply to an earlier post i meant each new page containing data that can be printed within the document.
.i followed the paste special/link instructions after talking with my uncle & deciding thats what he wanted, but it didn't work properly. i followed the instructions you gave me up until i got to the paste link button but i couldn't do this instruction "select MS Excel WS Obj from the "As:" list" because i didn't know what you meant. how do i do this? will this mean that the selected information will automatically appear on each new page of the document? i've supplied an attachment to show you what i want to repeat, if you could walk me threw it i'd appreciate it & a speedy response would be appreciated even more
also i meant each new page that can print data in the document.
Thanks A Lot