Group:  Microsoft Excel ยป microsoft.public.excel.newusers
Thread: creating a table automatically

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

creating a table automatically
robnw11 <robnw11.2awm68_1152828012.751[ at ]excelforum-nospam.com> 13.07.2006 21:56:23
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?action=getinfo&userid=36339 View this thread: http://www.excelforum.com/showthread.php?threadid=561283
Re: creating a table automatically
protonLeah <protonLeah.2awy7k_1152843622.7326[ at ]excelforum-nospam.com> 14.07.2006 02:19:22
- 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?action=getinfo&userid=32097 View this thread: http://www.excelforum.com/showthread.php?threadid=561283
Re: creating a table automatically
"Otto Moehrbach" <ottokmnop[ at ]comcast.net> 14.07.2006 21:40:52
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" <robnw11.2awm68_1152828012.751[ at ]excelforum-nospam.com> wrote in
message news:robnw11.2awm68_1152828012.751[ at ]excelforum-nospam.com...
[Quoted Text]
>
> 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?action=getinfo&userid=36339
> View this thread: http://www.excelforum.com/showthread.php?threadid=561283
>


Re: creating a table automatically
robnw11 <robnw11.2b0596_1152992744.0853[ at ]excelforum-nospam.com> 15.07.2006 19:44:08
thanks a lot to both of you, i'll try the advice out now. -- robnw11 ------------------------------------------------------------------------ robnw11's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36339 View this thread: http://www.excelforum.com/showthread.php?threadid=561283
Re: creating a table automatically
robnw11 <robnw11.2bet17_1153676709.4582[ at ]excelforum-nospam.com> 23.07.2006 17:41:11
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?action=getinfo&userid=36339 View this thread: http://www.excelforum.com/showthread.php?threadid=561283

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net