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

- Select the cells in Excel spreadsheet you desire to insert and
copy.
- 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
- O.K.


--
protonLeah


------------------------------------------------------------------------
protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097
View this thread: http://www.excelforum.com/showthread...hreadid=561283

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" wrote in
message ...

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

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


--
robnw11
------------------------------------------------------------------------
robnw11's Profile: http://www.excelforum.com/member.php...o&userid=36339
View this thread: http://www.excelforum.com/showthread...hreadid=561283

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? thanks a lot


--
robnw11
------------------------------------------------------------------------
robnw11's Profile: http://www.excelforum.com/member.php...o&userid=36339
View this thread: http://www.excelforum.com/showthread...hreadid=561283