P
Pat Brewington
Is there a way to combine 3 workbooks into one?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
O
Otto Moehrbach
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
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
O
Otto Moehrbach
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
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
P
Pat Brewington
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.
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.
O
Otto Moehrbach
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
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
P
Pat Brewington
I want the new workbook to simply have all the sheets from the 3 work books.
Sorry about not being clearer.
Sorry about not being clearer.
O
Otto Moehrbach
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
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
O
Otto Moehrbach
You have to furnish more details about these 2 workbooks.
Also, regarding this input page, what will he type in that will allow Excel
to determine what sheet to place that input?
Provide details about the input page. How many cells in the input? What
does each cell entry represent? How many sheets are there? What are the
sheet names? HTH Otto
Also, regarding this input page, what will he type in that will allow Excel
to determine what sheet to place that input?
Provide details about the input page. How many cells in the input? What
does each cell entry represent? How many sheets are there? What are the
sheet names? HTH Otto
psyksmasher70 via OfficeKB.com said: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 said: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[quoted text clipped - 10 lines]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,Otto
Is there a way to combine 3 workbooks into one?
O
Otto Moehrbach
Believe me, if he has little knowledge of Excel, you don't want to give him
some VBA to play with. Many things can happen to create an error and when
that happens, the VBA stops cold. What I gave you is straight forward and
easy to master. Otto
some VBA to play with. Many things can happen to create an error and when
that happens, the VBA stops cold. What I gave you is straight forward and
easy to master. Otto
psyksmasher70 via OfficeKB.com said:?If you can, send me the VBA, maybe that would be easier for him. Please?
Otto said: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
[quoted text clipped - 62 lines]I want the new workbook to simply have all the sheets from the 3 work
books.Otto
Is there a way to combine 3 workbooks into one?