Splitting a workbook

[Tony Vella]

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.

 

[gumby]

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

 

[Bill Ridgeway]

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