| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create multiple workbooks within one workbook
How many sheets in each of the 5 workbooks?
Do these sheets have unique names that would not be duplicated in each of the 5 workbooks? Maybe just move the sheets from each workbook into one new workbook. You can do that manually. Select all sheets in a workbook at once and right-click on active sheet tab and Move or CopyCreate a copy Otherwise you get into VBA which Ron de Bruin covers very well at his site. http://www.rondebruin.nl/tips.htm Scroll down to Copy/Paste/Merge Examples Gord Dibben MS Excel MVP On Wed, 19 Aug 2009 14:23:01 -0700, Ken C wrote: I'm not a programmer so this may sound dumb, but how do I create one workbook combining about 5 workbooks or better yet take 5 workbooks and put them all into one master workbook where they cam be tabed through. I'm not versed on vb so I don't understand it very much. Any help would be greatly appreciated. Ken C. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create multiple workbooks within one workbook
tHE NUMBER OF SHEETS IN EACH OF THE WORKBOOKS VARIES, THE TRADE JOURNAL WILL
HAVE NUMERIOUS SHEETS IN THEM NAMES BY EACH DIFFERENT STOCK TRADED. I WAS WANTING TO BE ABLE TO HAVE IT TO WHERE I COULD JUST JUMP FROM THE TRADE JOURNAL TO THE PROFIT/LOSS SHEET TO ENTER DATA AND TO BE ABLE TO GO FROM THE SMO1 OR 2 SHEETS TO THE TRADE JOURNAL BOOK TO EHTER THE STOCK PER SHEET. SO YOU SEE THAT THE TRADE JOURNAL BOOK WILL GET VERY LARGE SO IT WOULDN'T BE TOO PRODUCTIVE TO HAVE THEM ALL IN ONE WORKBOOK UNLESS I CAN HAVE IT TO WHERE I COULD HAVE THEM TABBED TO GO BETWEEN THEM. "Gord Dibben" wrote: How many sheets in each of the 5 workbooks? Do these sheets have unique names that would not be duplicated in each of the 5 workbooks? Maybe just move the sheets from each workbook into one new workbook. You can do that manually. Select all sheets in a workbook at once and right-click on active sheet tab and Move or CopyCreate a copy Otherwise you get into VBA which Ron de Bruin covers very well at his site. http://www.rondebruin.nl/tips.htm Scroll down to Copy/Paste/Merge Examples Gord Dibben MS Excel MVP On Wed, 19 Aug 2009 14:23:01 -0700, Ken C wrote: I'm not a programmer so this may sound dumb, but how do I create one workbook combining about 5 workbooks or better yet take 5 workbooks and put them all into one master workbook where they cam be tabed through. I'm not versed on vb so I don't understand it very much. Any help would be greatly appreciated. Ken C. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create multiple workbooks within one workbook
It is possible to have multiple workbooks open in a single session of Excel.
You can even have multiple windows with a workbook/sheet in each window. Would that serve your purpose? Also............please drop the CAPS.......hard to read and very hard on the ears. Gord On Wed, 19 Aug 2009 15:46:07 -0700, Ken C wrote: tHE NUMBER OF SHEETS IN EACH OF THE WORKBOOKS VARIES, THE TRADE JOURNAL WILL HAVE NUMERIOUS SHEETS IN THEM NAMES BY EACH DIFFERENT STOCK TRADED. I WAS WANTING TO BE ABLE TO HAVE IT TO WHERE I COULD JUST JUMP FROM THE TRADE JOURNAL TO THE PROFIT/LOSS SHEET TO ENTER DATA AND TO BE ABLE TO GO FROM THE SMO1 OR 2 SHEETS TO THE TRADE JOURNAL BOOK TO EHTER THE STOCK PER SHEET. SO YOU SEE THAT THE TRADE JOURNAL BOOK WILL GET VERY LARGE SO IT WOULDN'T BE TOO PRODUCTIVE TO HAVE THEM ALL IN ONE WORKBOOK UNLESS I CAN HAVE IT TO WHERE I COULD HAVE THEM TABBED TO GO BETWEEN THEM. "Gord Dibben" wrote: How many sheets in each of the 5 workbooks? Do these sheets have unique names that would not be duplicated in each of the 5 workbooks? Maybe just move the sheets from each workbook into one new workbook. You can do that manually. Select all sheets in a workbook at once and right-click on active sheet tab and Move or CopyCreate a copy Otherwise you get into VBA which Ron de Bruin covers very well at his site. http://www.rondebruin.nl/tips.htm Scroll down to Copy/Paste/Merge Examples Gord Dibben MS Excel MVP On Wed, 19 Aug 2009 14:23:01 -0700, Ken C wrote: I'm not a programmer so this may sound dumb, but how do I create one workbook combining about 5 workbooks or better yet take 5 workbooks and put them all into one master workbook where they cam be tabed through. I'm not versed on vb so I don't understand it very much. Any help would be greatly appreciated. Ken C. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create multiple workbooks within one workbook
Sorry about the caps I didn't notice them untill I submitted it. No multiple
workbooks open at the same time won't work due to the fact that some of the data is also used on the others. If you go to the TraderXL.com website and download and install either anilizerxl or traderxl you will see what I'm trying to do. "Gord Dibben" wrote: It is possible to have multiple workbooks open in a single session of Excel. You can even have multiple windows with a workbook/sheet in each window. Would that serve your purpose? Also............please drop the CAPS.......hard to read and very hard on the ears. Gord On Wed, 19 Aug 2009 15:46:07 -0700, Ken C wrote: tHE NUMBER OF SHEETS IN EACH OF THE WORKBOOKS VARIES, THE TRADE JOURNAL WILL HAVE NUMERIOUS SHEETS IN THEM NAMES BY EACH DIFFERENT STOCK TRADED. I WAS WANTING TO BE ABLE TO HAVE IT TO WHERE I COULD JUST JUMP FROM THE TRADE JOURNAL TO THE PROFIT/LOSS SHEET TO ENTER DATA AND TO BE ABLE TO GO FROM THE SMO1 OR 2 SHEETS TO THE TRADE JOURNAL BOOK TO EHTER THE STOCK PER SHEET. SO YOU SEE THAT THE TRADE JOURNAL BOOK WILL GET VERY LARGE SO IT WOULDN'T BE TOO PRODUCTIVE TO HAVE THEM ALL IN ONE WORKBOOK UNLESS I CAN HAVE IT TO WHERE I COULD HAVE THEM TABBED TO GO BETWEEN THEM. "Gord Dibben" wrote: How many sheets in each of the 5 workbooks? Do these sheets have unique names that would not be duplicated in each of the 5 workbooks? Maybe just move the sheets from each workbook into one new workbook. You can do that manually. Select all sheets in a workbook at once and right-click on active sheet tab and Move or CopyCreate a copy Otherwise you get into VBA which Ron de Bruin covers very well at his site. http://www.rondebruin.nl/tips.htm Scroll down to Copy/Paste/Merge Examples Gord Dibben MS Excel MVP On Wed, 19 Aug 2009 14:23:01 -0700, Ken C wrote: I'm not a programmer so this may sound dumb, but how do I create one workbook combining about 5 workbooks or better yet take 5 workbooks and put them all into one master workbook where they cam be tabed through. I'm not versed on vb so I don't understand it very much. Any help would be greatly appreciated. Ken C. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create multiple workbooks within one workbook
Thanks for the offer but I am happy with my Excel and don't need any other
applications. Perhaps you could post a screen shot to one of these sites. http://www.freefilehosting.net/ http://savefile.com/ After uploading, post the URL. I don't understand this statement No multiple workbooks open at the same time won't work due to the fact that some of the data is also used on the others Gord On Wed, 19 Aug 2009 16:15:02 -0700, Ken C wrote: Sorry about the caps I didn't notice them untill I submitted it. No multiple workbooks open at the same time won't work due to the fact that some of the data is also used on the others. If you go to the TraderXL.com website and download and install either anilizerxl or traderxl you will see what I'm trying to do. "Gord Dibben" wrote: It is possible to have multiple workbooks open in a single session of Excel. You can even have multiple windows with a workbook/sheet in each window. Would that serve your purpose? Also............please drop the CAPS.......hard to read and very hard on the ears. Gord On Wed, 19 Aug 2009 15:46:07 -0700, Ken C wrote: tHE NUMBER OF SHEETS IN EACH OF THE WORKBOOKS VARIES, THE TRADE JOURNAL WILL HAVE NUMERIOUS SHEETS IN THEM NAMES BY EACH DIFFERENT STOCK TRADED. I WAS WANTING TO BE ABLE TO HAVE IT TO WHERE I COULD JUST JUMP FROM THE TRADE JOURNAL TO THE PROFIT/LOSS SHEET TO ENTER DATA AND TO BE ABLE TO GO FROM THE SMO1 OR 2 SHEETS TO THE TRADE JOURNAL BOOK TO EHTER THE STOCK PER SHEET. SO YOU SEE THAT THE TRADE JOURNAL BOOK WILL GET VERY LARGE SO IT WOULDN'T BE TOO PRODUCTIVE TO HAVE THEM ALL IN ONE WORKBOOK UNLESS I CAN HAVE IT TO WHERE I COULD HAVE THEM TABBED TO GO BETWEEN THEM. "Gord Dibben" wrote: How many sheets in each of the 5 workbooks? Do these sheets have unique names that would not be duplicated in each of the 5 workbooks? Maybe just move the sheets from each workbook into one new workbook. You can do that manually. Select all sheets in a workbook at once and right-click on active sheet tab and Move or CopyCreate a copy Otherwise you get into VBA which Ron de Bruin covers very well at his site. http://www.rondebruin.nl/tips.htm Scroll down to Copy/Paste/Merge Examples Gord Dibben MS Excel MVP On Wed, 19 Aug 2009 14:23:01 -0700, Ken C wrote: I'm not a programmer so this may sound dumb, but how do I create one workbook combining about 5 workbooks or better yet take 5 workbooks and put them all into one master workbook where they cam be tabed through. I'm not versed on vb so I don't understand it very much. Any help would be greatly appreciated. Ken C. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create multiple workbooks within one workbook
You can view the demo of the program that show it at this url
http://traderxl.com/axl2003.htm "Gord Dibben" wrote: Thanks for the offer but I am happy with my Excel and don't need any other applications. Perhaps you could post a screen shot to one of these sites. http://www.freefilehosting.net/ http://savefile.com/ After uploading, post the URL. I don't understand this statement No multiple workbooks open at the same time won't work due to the fact that some of the data is also used on the others Gord On Wed, 19 Aug 2009 16:15:02 -0700, Ken C wrote: Sorry about the caps I didn't notice them untill I submitted it. No multiple workbooks open at the same time won't work due to the fact that some of the data is also used on the others. If you go to the TraderXL.com website and download and install either anilizerxl or traderxl you will see what I'm trying to do. "Gord Dibben" wrote: It is possible to have multiple workbooks open in a single session of Excel. You can even have multiple windows with a workbook/sheet in each window. Would that serve your purpose? Also............please drop the CAPS.......hard to read and very hard on the ears. Gord On Wed, 19 Aug 2009 15:46:07 -0700, Ken C wrote: tHE NUMBER OF SHEETS IN EACH OF THE WORKBOOKS VARIES, THE TRADE JOURNAL WILL HAVE NUMERIOUS SHEETS IN THEM NAMES BY EACH DIFFERENT STOCK TRADED. I WAS WANTING TO BE ABLE TO HAVE IT TO WHERE I COULD JUST JUMP FROM THE TRADE JOURNAL TO THE PROFIT/LOSS SHEET TO ENTER DATA AND TO BE ABLE TO GO FROM THE SMO1 OR 2 SHEETS TO THE TRADE JOURNAL BOOK TO EHTER THE STOCK PER SHEET. SO YOU SEE THAT THE TRADE JOURNAL BOOK WILL GET VERY LARGE SO IT WOULDN'T BE TOO PRODUCTIVE TO HAVE THEM ALL IN ONE WORKBOOK UNLESS I CAN HAVE IT TO WHERE I COULD HAVE THEM TABBED TO GO BETWEEN THEM. "Gord Dibben" wrote: How many sheets in each of the 5 workbooks? Do these sheets have unique names that would not be duplicated in each of the 5 workbooks? Maybe just move the sheets from each workbook into one new workbook. You can do that manually. Select all sheets in a workbook at once and right-click on active sheet tab and Move or CopyCreate a copy Otherwise you get into VBA which Ron de Bruin covers very well at his site. http://www.rondebruin.nl/tips.htm Scroll down to Copy/Paste/Merge Examples Gord Dibben MS Excel MVP On Wed, 19 Aug 2009 14:23:01 -0700, Ken C wrote: I'm not a programmer so this may sound dumb, but how do I create one workbook combining about 5 workbooks or better yet take 5 workbooks and put them all into one master workbook where they cam be tabed through. I'm not versed on vb so I don't understand it very much. Any help would be greatly appreciated. Ken C. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create multiple workbooks within one workbook
I tried to post to one of the two websites that you mentioned but was unable
to upload the jpeg file, that is the reason that I posted the url address that shows the inteerface that it uses. "Ken C" wrote: You can view the demo of the program that show it at this url http://traderxl.com/axl2003.htm "Gord Dibben" wrote: Thanks for the offer but I am happy with my Excel and don't need any other applications. Perhaps you could post a screen shot to one of these sites. http://www.freefilehosting.net/ http://savefile.com/ After uploading, post the URL. I don't understand this statement No multiple workbooks open at the same time won't work due to the fact that some of the data is also used on the others Gord On Wed, 19 Aug 2009 16:15:02 -0700, Ken C wrote: Sorry about the caps I didn't notice them untill I submitted it. No multiple workbooks open at the same time won't work due to the fact that some of the data is also used on the others. If you go to the TraderXL.com website and download and install either anilizerxl or traderxl you will see what I'm trying to do. "Gord Dibben" wrote: It is possible to have multiple workbooks open in a single session of Excel. You can even have multiple windows with a workbook/sheet in each window. Would that serve your purpose? Also............please drop the CAPS.......hard to read and very hard on the ears. Gord On Wed, 19 Aug 2009 15:46:07 -0700, Ken C wrote: tHE NUMBER OF SHEETS IN EACH OF THE WORKBOOKS VARIES, THE TRADE JOURNAL WILL HAVE NUMERIOUS SHEETS IN THEM NAMES BY EACH DIFFERENT STOCK TRADED. I WAS WANTING TO BE ABLE TO HAVE IT TO WHERE I COULD JUST JUMP FROM THE TRADE JOURNAL TO THE PROFIT/LOSS SHEET TO ENTER DATA AND TO BE ABLE TO GO FROM THE SMO1 OR 2 SHEETS TO THE TRADE JOURNAL BOOK TO EHTER THE STOCK PER SHEET. SO YOU SEE THAT THE TRADE JOURNAL BOOK WILL GET VERY LARGE SO IT WOULDN'T BE TOO PRODUCTIVE TO HAVE THEM ALL IN ONE WORKBOOK UNLESS I CAN HAVE IT TO WHERE I COULD HAVE THEM TABBED TO GO BETWEEN THEM. "Gord Dibben" wrote: How many sheets in each of the 5 workbooks? Do these sheets have unique names that would not be duplicated in each of the 5 workbooks? Maybe just move the sheets from each workbook into one new workbook. You can do that manually. Select all sheets in a workbook at once and right-click on active sheet tab and Move or CopyCreate a copy Otherwise you get into VBA which Ron de Bruin covers very well at his site. http://www.rondebruin.nl/tips.htm Scroll down to Copy/Paste/Merge Examples Gord Dibben MS Excel MVP On Wed, 19 Aug 2009 14:23:01 -0700, Ken C wrote: I'm not a programmer so this may sound dumb, but how do I create one workbook combining about 5 workbooks or better yet take 5 workbooks and put them all into one master workbook where they cam be tabed through. I'm not versed on vb so I don't understand it very much. Any help would be greatly appreciated. Ken C. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create multiple workbooks within one workbook
Nice Demo but I think all the functions are a result of the application
interfacing with Excel. I do not have the skills nor time to create anything similar. Gord On Wed, 19 Aug 2009 17:38:04 -0700, Ken C wrote: You can view the demo of the program that show it at this url http://traderxl.com/axl2003.htm "Gord Dibben" wrote: Thanks for the offer but I am happy with my Excel and don't need any other applications. Perhaps you could post a screen shot to one of these sites. http://www.freefilehosting.net/ http://savefile.com/ After uploading, post the URL. I don't understand this statement No multiple workbooks open at the same time won't work due to the fact that some of the data is also used on the others Gord On Wed, 19 Aug 2009 16:15:02 -0700, Ken C wrote: Sorry about the caps I didn't notice them untill I submitted it. No multiple workbooks open at the same time won't work due to the fact that some of the data is also used on the others. If you go to the TraderXL.com website and download and install either anilizerxl or traderxl you will see what I'm trying to do. "Gord Dibben" wrote: It is possible to have multiple workbooks open in a single session of Excel. You can even have multiple windows with a workbook/sheet in each window. Would that serve your purpose? Also............please drop the CAPS.......hard to read and very hard on the ears. Gord On Wed, 19 Aug 2009 15:46:07 -0700, Ken C wrote: tHE NUMBER OF SHEETS IN EACH OF THE WORKBOOKS VARIES, THE TRADE JOURNAL WILL HAVE NUMERIOUS SHEETS IN THEM NAMES BY EACH DIFFERENT STOCK TRADED. I WAS WANTING TO BE ABLE TO HAVE IT TO WHERE I COULD JUST JUMP FROM THE TRADE JOURNAL TO THE PROFIT/LOSS SHEET TO ENTER DATA AND TO BE ABLE TO GO FROM THE SMO1 OR 2 SHEETS TO THE TRADE JOURNAL BOOK TO EHTER THE STOCK PER SHEET. SO YOU SEE THAT THE TRADE JOURNAL BOOK WILL GET VERY LARGE SO IT WOULDN'T BE TOO PRODUCTIVE TO HAVE THEM ALL IN ONE WORKBOOK UNLESS I CAN HAVE IT TO WHERE I COULD HAVE THEM TABBED TO GO BETWEEN THEM. "Gord Dibben" wrote: How many sheets in each of the 5 workbooks? Do these sheets have unique names that would not be duplicated in each of the 5 workbooks? Maybe just move the sheets from each workbook into one new workbook. You can do that manually. Select all sheets in a workbook at once and right-click on active sheet tab and Move or CopyCreate a copy Otherwise you get into VBA which Ron de Bruin covers very well at his site. http://www.rondebruin.nl/tips.htm Scroll down to Copy/Paste/Merge Examples Gord Dibben MS Excel MVP On Wed, 19 Aug 2009 14:23:01 -0700, Ken C wrote: I'm not a programmer so this may sound dumb, but how do I create one workbook combining about 5 workbooks or better yet take 5 workbooks and put them all into one master workbook where they cam be tabed through. I'm not versed on vb so I don't understand it very much. Any help would be greatly appreciated. Ken C. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create formula that combines numbers from multiple workBOOKS? | Excel Discussion (Misc queries) | |||
| Can I create a 3-D reference from multiple workbooks | Excel Worksheet Functions | |||
| Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) | |||
| Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) | |||
| Create different workbooks from only one workbook | Excel Worksheet Functions | |||
Hybrid Mode
