|
| 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
May 18th, 2009, 07:25 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
How do I number pages consistently using different files?
There are about 12 files and they need to be combined. Knowing that all 12
files will be 70 pages total, how do I number each file so that the pages will be numbered? Example: A folder has 2 pages but they are pages 7 of 70 and 8 of 70. 
|
|
#2
May 18th, 2009, 09:29 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I number pages consistently using different files?
In Excel vernacular a file is a "workbook" which can contain one or more
"worksheets" each of which can have one or more "pages". A "page" is what is printed. 12 workbooks to be combined into one workbook? How many worksheets in each workbook? Are all worksheets to be combined into one worksheet in the new workbook or remain as their own sheets? What order would the combining take..........workbooks and/or sheets? How many pages on each worksheet? A folder has 2 pages but they are pages 7 of 70 and 8 of 70. Folders contain files, not pages. Gord Dibben MS Excel MVP On Mon, 18 May 2009 11:25:27 -0700, sswillis wrote: There are about 12 files and they need to be combined. Knowing that all 12 files will be 70 pages total, how do I number each file so that the pages will be numbered? Example: A folder has 2 pages but they are pages 7 of 70 and 8 of 70.
|
|
#3
May 18th, 2009, 10:38 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I number pages consistently using different files?
"Gord Dibben" wrote: In Excel vernacular a file is a "workbook" which can contain one or more "worksheets" each of which can have one or more "pages". I agree with you. A "page" is what is printed. 12 workbooks to be combined into one workbook? Yes, but they are not all in one file. There are 12 different files that you have to open, number, save, and close that will be put on one (1) worksheet is my understanding. How many worksheets in each workbook? There will only be one (1) Are all worksheets to be combined into one worksheet in the new workbook or remain as their own sheets? YES. Sry I answered this above. What order would the combining take..........workbooks and/or sheets? Sheets How many pages on each worksheet? There are 63 pages. A folder has 2 pages but they are pages 7 of 70 and 8 of 70. Folders contain files, not pages. YES. There are 12 different files, not pages, that will be combined on a worksheet to make 63 pages. Gord Dibben MS Excel MVP On Mon, 18 May 2009 11:25:27 -0700, sswillis wrote: There are about 12 files and they need to be combined. Knowing that all 12 files will be 70 pages total, how do I number each file so that the pages will be numbered? Example: A folder has 2 pages but they are pages 7 of 70 and 8 of 70.
|
|
#4
May 18th, 2009, 11:02 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I number pages consistently using different files?
One of us is still confused about what you want.
You have 12 files(workbooks) each with one worksheet..........is that correct? You want to open each of those workbooks and copy the data from the single worksheet into one new worksheet in a new workbook..............is that correct? So now you will have one new workbook with the 12 single sheets combined into one sheet which will have 63 pages..............is that correct? Manually you can create a new workbook from FileNewBlank workbook. Then open workbook1 and copy the data from the lone worksheet into Sheet1 of new book. You decide which order to open the workbooks and copy/paste. Close workbook1 and open workbook2...........copy the data from the lone worksheet and paste below what you pasted from workbook1 Etc. Etc. until you have 63 pages of data on Sheet1 of new workbook. Gord On Mon, 18 May 2009 14:38:02 -0700, sswillis wrote: "Gord Dibben" wrote: In Excel vernacular a file is a "workbook" which can contain one or more "worksheets" each of which can have one or more "pages". I agree with you. A "page" is what is printed. 12 workbooks to be combined into one workbook? Yes, but they are not all in one file. There are 12 different files that you have to open, number, save, and close that will be put on one (1) worksheet is my understanding. How many worksheets in each workbook? There will only be one (1) Are all worksheets to be combined into one worksheet in the new workbook or remain as their own sheets? YES. Sry I answered this above. What order would the combining take..........workbooks and/or sheets? Sheets How many pages on each worksheet? There are 63 pages. A folder has 2 pages but they are pages 7 of 70 and 8 of 70. Folders contain files, not pages. YES. There are 12 different files, not pages, that will be combined on a worksheet to make 63 pages. Gord Dibben MS Excel MVP On Mon, 18 May 2009 11:25:27 -0700, sswillis wrote: There are about 12 files and they need to be combined. Knowing that all 12 files will be 70 pages total, how do I number each file so that the pages will be numbered? Example: A folder has 2 pages but they are pages 7 of 70 and 8 of 70.
|
|
#5
May 19th, 2009, 01:36 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I number pages consistently using different files?
The SUPERVISOR states:
All of the worksheets will NOT be copied and pasted into one worksheet. Some of the worksheets, within the different files, will be printed out and made a hard copy file once printed. Therefore, the pages that are going to be printed out need to be numbered manually (while in their seperate files) for the printout. MS Office 2003 allows us to number the needed pages manually, but 2007 is not doing it. I am using 2007. Thank you. "Gord Dibben" wrote: One of us is still confused about what you want. You have 12 files(workbooks) each with one worksheet..........is that correct? You want to open each of those workbooks and copy the data from the single worksheet into one new worksheet in a new workbook..............is that correct? So now you will have one new workbook with the 12 single sheets combined into one sheet which will have 63 pages..............is that correct? Manually you can create a new workbook from FileNewBlank workbook. Then open workbook1 and copy the data from the lone worksheet into Sheet1 of new book. You decide which order to open the workbooks and copy/paste. Close workbook1 and open workbook2...........copy the data from the lone worksheet and paste below what you pasted from workbook1 Etc. Etc. until you have 63 pages of data on Sheet1 of new workbook. Gord On Mon, 18 May 2009 14:38:02 -0700, sswillis wrote: "Gord Dibben" wrote: In Excel vernacular a file is a "workbook" which can contain one or more "worksheets" each of which can have one or more "pages". I agree with you. A "page" is what is printed. 12 workbooks to be combined into one workbook? Yes, but they are not all in one file. There are 12 different files that you have to open, number, save, and close that will be put on one (1) worksheet is my understanding. How many worksheets in each workbook? There will only be one (1) Are all worksheets to be combined into one worksheet in the new workbook or remain as their own sheets? YES. Sry I answered this above. What order would the combining take..........workbooks and/or sheets? Sheets How many pages on each worksheet? There are 63 pages. A folder has 2 pages but they are pages 7 of 70 and 8 of 70. Folders contain files, not pages. YES. There are 12 different files, not pages, that will be combined on a worksheet to make 63 pages. Gord Dibben MS Excel MVP On Mon, 18 May 2009 11:25:27 -0700, sswillis wrote: There are about 12 files and they need to be combined. Knowing that all 12 files will be 70 pages total, how do I number each file so that the pages will be numbered? Example: A folder has 2 pages but they are pages 7 of 70 and 8 of 70.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
