Spliting data into different sheets

  • Thread starter Thread starter JJ
  • Start date Start date
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
 
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
 
Back
Top