Is there a way to combine 3 workbooks into one?

Pat
There is a lot of gray area in what you ask. Post back and tell us a
little bit about the 3 workbooks you have (same sheets names?, same
headers?, etc?). Then tell us what you want the final product to look like.
For instance, do you want some data appended to other data, or do you want
all the data to be in separate sheets but all in the one workbook, etc. HTH
Otto
"Pat Brewington" <(E-Mail Removed)> wrote in message
news:C199ADD7.1BA1%(E-Mail Removed)...
> Is there a way to combine 3 workbooks into one?
>

Otto Moehrbach wrote:
> Pat
> There is a lot of gray area in what you ask. Post back and tell us a
> little bit about the 3 workbooks you have (same sheets names?, same
> headers?, etc?). Then tell us what you want the final product to look like.
> For instance, do you want some data appended to other data, or do you want
> all the data to be in separate sheets but all in the one workbook, etc. HTH
> Otto
> "Pat Brewington" <(E-Mail Removed)> wrote in message
> news:C199ADD7.1BA1%(E-Mail Removed)...
>> Is there a way to combine 3 workbooks into one?
>>
>
>
Know this is off subject but wish to contact you about updating the
invoice template you did for us a few years ago. E-mails are bouncing
back to previous address. Pardon this intrusion.

Ed

I have somewhat the same issue, but need to create a page that allows an
entry and automatically adds it to it's perspective page. Please help,
psyksmasher70.

Otto Moehrbach wrote:
>Pat
> There is a lot of gray area in what you ask. Post back and tell us a
>little bit about the 3 workbooks you have (same sheets names?, same
>headers?, etc?). Then tell us what you want the final product to look like.
>For instance, do you want some data appended to other data, or do you want
>all the data to be in separate sheets but all in the one workbook, etc. HTH
>Otto
>> Is there a way to combine 3 workbooks into one?

Provide more info on what you have. Also about the entry you want to make
and how the entry can be identified as needing to be placed in some specific
sheet. Is the entry one cell? If not, provide info on how many cells and
what they represent. HTH Otto
"psyksmasher70" <u30039@uwe> wrote in message news:6a6eea19c0d91@uwe...
>I have somewhat the same issue, but need to create a page that allows an
> entry and automatically adds it to it's perspective page. Please help,
> psyksmasher70.
>
> Otto Moehrbach wrote:
>>Pat
>> There is a lot of gray area in what you ask. Post back and tell us a
>>little bit about the 3 workbooks you have (same sheets names?, same
>>headers?, etc?). Then tell us what you want the final product to look
>>like.
>>For instance, do you want some data appended to other data, or do you want
>>all the data to be in separate sheets but all in the one workbook, etc.
>>HTH
>>Otto
>>> Is there a way to combine 3 workbooks into one?
>

Each workbook represents a school district and has from 4 to 50 sheets
representing individual students. I'd like to combine the sheets from all
workbooks into one for quarterly reports and to regroup the information.
Any help would be great.


On 12/8/06 6:28 PM, in article (E-Mail Removed), "Otto
Moehrbach" <(E-Mail Removed)> wrote:

> Provide more info on what you have. Also about the entry you want to make
> and how the entry can be identified as needing to be placed in some specific
> sheet. Is the entry one cell? If not, provide info on how many cells and
> what they represent. HTH Otto
> "psyksmasher70" <u30039@uwe> wrote in message news:6a6eea19c0d91@uwe...
>> I have somewhat the same issue, but need to create a page that allows an
>> entry and automatically adds it to it's perspective page. Please help,
>> psyksmasher70.
>>
>> Otto Moehrbach wrote:
>>> Pat
>>> There is a lot of gray area in what you ask. Post back and tell us a
>>> little bit about the 3 workbooks you have (same sheets names?, same
>>> headers?, etc?). Then tell us what you want the final product to look
>>> like.
>>> For instance, do you want some data appended to other data, or do you want
>>> all the data to be in separate sheets but all in the one workbook, etc.
>>> HTH
>>> Otto
>>>> Is there a way to combine 3 workbooks into one?
>>
>
>

Pat
I have to ask the same questions I asked before.
Do all the sheets in all the workbooks have the same column or row headers?
Do you want the data from any sheets grouped into one sheet or do you want
the new combined workbook to simply have all the sheets from the 3
workbooks?
If you say that you want all the data from all the sheets in the 3
workbooks, all put into one sheet in the new workbook, note that one sheet
can hold no more than 65,536 rows.
Explain this like you would to a person who just walked in off the street,
probably looking for a bathroom, and has no idea or knowledge of your
business or what you want to do.
Say things like:
Put the data from this sheet and that sheet on one sheet.
Etc.
Etc.
HTH Otto
"Pat Brewington" <(E-Mail Removed)> wrote in message
news:C1A30643.1F5D%(E-Mail Removed)...
> Each workbook represents a school district and has from 4 to 50 sheets
> representing individual students. I'd like to combine the sheets from all
> workbooks into one for quarterly reports and to regroup the information.
> Any help would be great.
>
>
> On 12/8/06 6:28 PM, in article (E-Mail Removed),
> "Otto
> Moehrbach" <(E-Mail Removed)> wrote:
>
>> Provide more info on what you have. Also about the entry you want to
>> make
>> and how the entry can be identified as needing to be placed in some
>> specific
>> sheet. Is the entry one cell? If not, provide info on how many cells
>> and
>> what they represent. HTH Otto
>> "psyksmasher70" <u30039@uwe> wrote in message news:6a6eea19c0d91@uwe...
>>> I have somewhat the same issue, but need to create a page that allows an
>>> entry and automatically adds it to it's perspective page. Please help,
>>> psyksmasher70.
>>>
>>> Otto Moehrbach wrote:
>>>> Pat
>>>> There is a lot of gray area in what you ask. Post back and tell us
>>>> a
>>>> little bit about the 3 workbooks you have (same sheets names?, same
>>>> headers?, etc?). Then tell us what you want the final product to look
>>>> like.
>>>> For instance, do you want some data appended to other data, or do you
>>>> want
>>>> all the data to be in separate sheets but all in the one workbook, etc.
>>>> HTH
>>>> Otto
>>>>> Is there a way to combine 3 workbooks into one?
>>>
>>
>>
>

I want the new workbook to simply have all the sheets from the 3 work books.
Sorry about not being clearer.


On 12/11/06 2:07 PM, in article (E-Mail Removed), "Otto
Moehrbach" <(E-Mail Removed)> wrote:

> Pat
> I have to ask the same questions I asked before.
> Do all the sheets in all the workbooks have the same column or row headers?
> Do you want the data from any sheets grouped into one sheet or do you want
> the new combined workbook to simply have all the sheets from the 3
> workbooks?
> If you say that you want all the data from all the sheets in the 3
> workbooks, all put into one sheet in the new workbook, note that one sheet
> can hold no more than 65,536 rows.
> Explain this like you would to a person who just walked in off the street,
> probably looking for a bathroom, and has no idea or knowledge of your
> business or what you want to do.
> Say things like:
> Put the data from this sheet and that sheet on one sheet.
> Etc.
> Etc.
> HTH Otto
> "Pat Brewington" <(E-Mail Removed)> wrote in message
> news:C1A30643.1F5D%(E-Mail Removed)...
>> Each workbook represents a school district and has from 4 to 50 sheets
>> representing individual students. I'd like to combine the sheets from all
>> workbooks into one for quarterly reports and to regroup the information.
>> Any help would be great.
>>
>>
>> On 12/8/06 6:28 PM, in article (E-Mail Removed),
>> "Otto
>> Moehrbach" <(E-Mail Removed)> wrote:
>>
>>> Provide more info on what you have. Also about the entry you want to
>>> make
>>> and how the entry can be identified as needing to be placed in some
>>> specific
>>> sheet. Is the entry one cell? If not, provide info on how many cells
>>> and
>>> what they represent. HTH Otto
>>> "psyksmasher70" <u30039@uwe> wrote in message news:6a6eea19c0d91@uwe...
>>>> I have somewhat the same issue, but need to create a page that allows an
>>>> entry and automatically adds it to it's perspective page. Please help,
>>>> psyksmasher70.
>>>>
>>>> Otto Moehrbach wrote:
>>>>> Pat
>>>>> There is a lot of gray area in what you ask. Post back and tell us
>>>>> a
>>>>> little bit about the 3 workbooks you have (same sheets names?, same
>>>>> headers?, etc?). Then tell us what you want the final product to look
>>>>> like.
>>>>> For instance, do you want some data appended to other data, or do you
>>>>> want
>>>>> all the data to be in separate sheets but all in the one workbook, etc.
>>>>> HTH
>>>>> Otto
>>>>>> Is there a way to combine 3 workbooks into one?
>>>>
>>>
>>>
>>
>
>

My brother is trying to create 2 workbooks. One that has trading cards by
year, set, sub-set, card no. and friver, persective with dropbox on each
header. I am trying to see if I can an entry page that all he has to do is
enter a value or word that would place it on it's respective page by clicking
enter. Same with the driver workbook. Can be 2 workbooks, but same entry
formula. He's not too smart. Thank you



Otto Moehrbach wrote:
>Provide more info on what you have. Also about the entry you want to make
>and how the entry can be identified as needing to be placed in some specific
>sheet. Is the entry one cell? If not, provide info on how many cells and
>what they represent. HTH Otto
>>I have somewhat the same issue, but need to create a page that allows an
>> entry and automatically adds it to it's perspective page. Please help,
>[quoted text clipped - 10 lines]
>>>Otto
>>>> Is there a way to combine 3 workbooks into one?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200612/1

Pat
I was going to write you some VBA code to do what you want, but since
you say you want all the sheets from the 3 workbooks to go into the one
workbook, there is a much easier way to do that. Here are the steps:
Create/open the new workbook.
Open one of the 3 workbooks and have it on the screen.
At the bottom-left of the screen, you see the left-right scroll arrows that
allow you to scroll the sheet tabs.
Scroll to the far-left, first, sheet. Click on that sheet tab.
Scroll to the far right, last, sheet tab.
Hold the SHIFT key down and click on that last sheet tab.
You have just grouped all the sheets together.
Click on Edit - Move or Copy Sheets.
In the little box that appears there is a checkbox labeled "Create a copy".
Check that box.
In the "To book:" space, select the new workbook.
In the "Before sheet:" space, select where in the new workbook sheets you
want to place the copied sheets.
Click OK.
Done
Repeat this with the other 2 workbooks.
HTH Otto

"Pat Brewington" <(E-Mail Removed)> wrote in message
news:C1A46C80.1FC2%(E-Mail Removed)...
>I want the new workbook to simply have all the sheets from the 3 work
>books.
> Sorry about not being clearer.
>
>
> On 12/11/06 2:07 PM, in article (E-Mail Removed),
> "Otto
> Moehrbach" <(E-Mail Removed)> wrote:
>
>> Pat
>> I have to ask the same questions I asked before.
>> Do all the sheets in all the workbooks have the same column or row
>> headers?
>> Do you want the data from any sheets grouped into one sheet or do you
>> want
>> the new combined workbook to simply have all the sheets from the 3
>> workbooks?
>> If you say that you want all the data from all the sheets in the 3
>> workbooks, all put into one sheet in the new workbook, note that one
>> sheet
>> can hold no more than 65,536 rows.
>> Explain this like you would to a person who just walked in off the
>> street,
>> probably looking for a bathroom, and has no idea or knowledge of your
>> business or what you want to do.
>> Say things like:
>> Put the data from this sheet and that sheet on one sheet.
>> Etc.
>> Etc.
>> HTH Otto
>> "Pat Brewington" <(E-Mail Removed)> wrote in message
>> news:C1A30643.1F5D%(E-Mail Removed)...
>>> Each workbook represents a school district and has from 4 to 50 sheets
>>> representing individual students. I'd like to combine the sheets from
>>> all
>>> workbooks into one for quarterly reports and to regroup the information.
>>> Any help would be great.
>>>
>>>
>>> On 12/8/06 6:28 PM, in article (E-Mail Removed),
>>> "Otto
>>> Moehrbach" <(E-Mail Removed)> wrote:
>>>
>>>> Provide more info on what you have. Also about the entry you want to
>>>> make
>>>> and how the entry can be identified as needing to be placed in some
>>>> specific
>>>> sheet. Is the entry one cell? If not, provide info on how many cells
>>>> and
>>>> what they represent. HTH Otto
>>>> "psyksmasher70" <u30039@uwe> wrote in message news:6a6eea19c0d91@uwe...
>>>>> I have somewhat the same issue, but need to create a page that allows
>>>>> an
>>>>> entry and automatically adds it to it's perspective page. Please help,
>>>>> psyksmasher70.
>>>>>
>>>>> Otto Moehrbach wrote:
>>>>>> Pat
>>>>>> There is a lot of gray area in what you ask. Post back and tell
>>>>>> us
>>>>>> a
>>>>>> little bit about the 3 workbooks you have (same sheets names?, same
>>>>>> headers?, etc?). Then tell us what you want the final product to
>>>>>> look
>>>>>> like.
>>>>>> For instance, do you want some data appended to other data, or do you
>>>>>> want
>>>>>> all the data to be in separate sheets but all in the one workbook,
>>>>>> etc.
>>>>>> HTH
>>>>>> Otto
>>>>>>> Is there a way to combine 3 workbooks into one?
>>>>>
>>>>
>>>>
>>>
>>
>>
>