Spliting data into different sheets

Giganews Newsgroups
Subject: Spliting data into different sheets
Posted by:  JJ (glensh…@yahoo.com)
Date: Wed, 15 Oct 2003

Hello

How can I split data from a master sheet to different
adhoc sheets based on certain criteria's, would I need to
use VBA or it there a function in excel?

Detail, there is data in columns A:F (multiple rows) in
the master sheet and the text in column A will determine
which sheet the row is to be copied to.

Any suggestions will be greatly appreciated.

Thanks

Replies