In need of an alternative to Excel Explosion

[mmc3587]

So I have a set of Data that I need to break up into specific tabs by specific info in one column. I need this data to populate in its proper tab instantly while still remaining in the master tab. I used excel explosion but it does not really help because it would be too time consuming constantly deleting the tabs and exploding again. Any suggestions?

 

[mwrohr]

I'd suggest AutoFilter and then copying visible rows to the appropriate sheet, then turning off the autofilter so your entire set is still there. I don't recall the exact syntax for the copy of the visible rows but should be in the help section?


edit: this is it - SpecialCells(xlCellTypeVisible)

so AutoFilter based on your column criteria the copy with the SpecialCells