|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 13th, 2006, 10:56 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
creating a table automatically
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 
|
|
#2
July 14th, 2006, 03:19 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
creating a table automatically
- 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
|
|
#3
July 14th, 2006, 10:40 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
creating a table automatically
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
|
|
#4
July 15th, 2006, 08:44 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
creating a table automatically
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
|
|
#5
July 23rd, 2006, 06:41 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
creating a table automatically
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Table problem | Redwood | Database Design | 29 | April 3rd, 2006 04:58 PM |
| Need to Improve Code Copying/Pasting Between Workbooks | David | General Discussion | 1 | January 6th, 2006 03:56 AM |
| Need to stop form from creating new records in table | Scott | General Discussion | 0 | December 15th, 2005 05:56 PM |
| Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
| Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. | HDW | Database Design | 3 | October 16th, 2004 03:42 AM |
Linear Mode
