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.

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.

"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.

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.

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.