Splitting a workbook

Is there an easier way for splitting a workbook into 2 smaller workbooks
than copying the workbook to 2 separate files and deleting the appropriate
worksheets from each? Thanks in advance.
--
Tony Vella in Ottawa, Canada

http://www.datapigtechnologies.com/freeware.htm

Tony Vella wrote:
> Is there an easier way for splitting a workbook into 2 smaller workbooks
> than copying the workbook to 2 separate files and deleting the appropriate
> worksheets from each? Thanks in advance.
> --
> Tony Vella in Ottawa, Canada

Why do you want to split the file? If you do you'll have to make sure that
any formula still reads the correct data. There is a case for not splitting
data over two or more spreadsheets (rather than worksheets within a
spreadsheet). If the data remains within a spreadsheet any formula will
change as cells are moved when data is added or removed. However, if data
is spread between spreadsheets formula will be looking at the right cell but
the incorrect data (unless cells are named).

Regards.

Bill Ridgeway
Computer Solutions

"Tony Vella" <[email protected]> wrote in message
news:[email protected]...
> Is there an easier way for splitting a workbook into 2 smaller workbooks
> than copying the workbook to 2 separate files and deleting the appropriate
> worksheets from each? Thanks in advance.
> --
> Tony Vella in Ottawa, Canada
>