View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How do I create multiple workbooks within one workbook

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.