Spliting data into different sheets

J

JJ

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
 
A

Arvi Laanemets

Hi

Set Autofilter on (you must have header row for it)
Set filter to some value in column A
Copy the filtered data, and paste into right sheet
Set filter to next value in column A
.....


Arvi Laanemets
 
Top