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.

You can't have multiple workbooks in one workbook, but you can have multiple
*worksheets* within one workbook, so if you want to combine data from
worksheets in a number of original workbooks, use "Move or Copy Sheet" to
transfer or copy a sheet from one workbook to another.
--
David Biddulph

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.

dAVID WHAT i WANT TO DO IS SOMETHING LIKE HAVE SOME TABBED AREAS AT THE TOP
OF THE PAGE TITLED: INDEX, TRADE JOURNAL, SMO1 TRADES, SMO2 TRADES,
PROFIT/LOSS. AND HAVE ALL OF THEM IN WONE WORKBOOK TO WHERE i CAN TAB IN
BETWEEN THEM SO THAT THE ONE WORKBOOK WOULDN'T GET SO BIG THAT i COULDN'T ADD
TO IT LATER. TRADERXL HAS THIS FEATURE TO TAB BETWEEN DIFFERENT TASKS AND I
WAS WANTING TO DO THE SAME. THE TABS WOULD BE LOCATED AT THE TOP OF THE PAGE
JUST UNDER EXCEL'S MENU.

"David Biddulph" wrote:

You can't have multiple workbooks in one workbook, but you can have multiple
*worksheets* within one workbook, so if you want to combine data from
worksheets in a number of original workbooks, use "Move or Copy Sheet" to
transfer or copy a sheet from one workbook to another.
--
David Biddulph

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.

Excel worksheet tabs are at the bottom of the window and cannot be moved
from that position.


Gord

On Wed, 19 Aug 2009 15:06:01 -0700, Ken C wrote:

dAVID WHAT i WANT TO DO IS SOMETHING LIKE HAVE SOME TABBED AREAS AT THE TOP
OF THE PAGE TITLED: INDEX, TRADE JOURNAL, SMO1 TRADES, SMO2 TRADES,
PROFIT/LOSS. AND HAVE ALL OF THEM IN WONE WORKBOOK TO WHERE i CAN TAB IN
BETWEEN THEM SO THAT THE ONE WORKBOOK WOULDN'T GET SO BIG THAT i COULDN'T ADD
TO IT LATER. TRADERXL HAS THIS FEATURE TO TAB BETWEEN DIFFERENT TASKS AND I
WAS WANTING TO DO THE SAME. THE TABS WOULD BE LOCATED AT THE TOP OF THE PAGE
JUST UNDER EXCEL'S MENU.

"David Biddulph" wrote:

You can't have multiple workbooks in one workbook, but you can have multiple
*worksheets* within one workbook, so if you want to combine data from
worksheets in a number of original workbooks, use "Move or Copy Sheet" to
transfer or copy a sheet from one workbook to another.
--
David Biddulph

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.

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.

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.

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.

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.

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.