creating a table automatically

  • Thread starter Thread starter robnw11
  • Start date Start date
R

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
 
- 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.
 
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
 
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
 
Back
Top