Move worksheet to new book

Giganews Newsgroups
Subject: Move worksheet to new book
Posted by:  Brian (babscl…@earthlink.net)
Date: Tue, 7 Oct 2003

I have 14 worksheets within a workbook.  In the middle are
worksheets named Sheet1, Sheet2....Sheet10  Is it possible
using a macro to see if there is anything written in cell
A1 on Sheet1, and if there is, then move it to a new book,
and then check Sheet2 and so on?  And if there is no
information on the worksheet I would like to delete it.

TIA

Replies