filter data with text filter and move to a new tab or spreadhseet?

[joeloveszoe]

hi
i have a large excel file that looks like this
is there a way to use the data filter in the sku column, to filter text ending in -BULK and move all entries to a new tab or spreadhseet?
thanks in advance for your help!
have a happy day!
j

listprice	productname	sku	status
69.99​	"Discipline" Silhouette Canvas Motivational Print, 22 x 28	AVT78097	FALSE​
4.01​	"Hello" Self-Adhesive Name Badges, 3 1/2 x 2 1/4, White/Blue, 100/Pack	UNV39105	FALSE​
50.2​	"Post Hole Digger, 5 3/4" point spread, 48" Handle	UNN78002	FALSE​
41.88​	"Thank You" Handled T-Shirt Bags, 11 1/2 x 21, Polyethylene, White, 900/Carton	IBSTHW1VAL	FALSE​
69.99​	"The Sky is the Limit" Silhouette Canvas Motivational Print, 22 x 28	AVT78095	FALSE​
9.28​	"TRASH ONLY" Decal w/Recycling Symbol, Black/White	RCPRC4	FALSE​
69.99​	"Unity" Silhouette Canvas Motivational Print, 22 x 28	AVT78094	FALSE​
4.01​	"Visitor" Self-Adhesive Name Badges, 3 1/2 x 2 1/4, White/Blue, 100/Pack	UNV39110	FALSE​
288.87​	#1 Paper Grocery Bag, 30lb Kraft, Standard 3 1/2 x 2 3/8 x 6 7/8, 8000 bags	BAGGK1	FALSE​
20.08​	#1 Paper Grocery Bag, 30lb Kraft, Standard 3 1/2 x 7 3/8 x 6 7/8, 500 bags	BAGGK1500	FALSE​
777.77​	#10 1/2 Healthcare Claim Form Envelopes with Security Tint and Gummed Closure for Use with Insurance Form CMS-1500 and Similar Forms, 24 lb White Wove, 4-1/8 x 9-1/2, 500 per Box	QUA21432A	FALSE​
162.26​	#10 1/2 Healthcare Claim Form Envelopes with Security Tint and Gummed Closure for Use with Insurance Form CMS-1500 and Similar Forms, 24 lb White Wove, 4-1/8 x 9-1/2, 500 per Box	QUA21432A-BULK	FALSE​
153.16​	#10 Paper Grocery Bag, 35lb Kraft, Standard 6 5/16 x 4 3/16 x 12 3/8, 2000 bags	BAGGK10	FALSE​
33.78​	#10 Paper Grocery Bag, 35lb Kraft, Standard 6 5/16 x 4 3/16 x 13 3/8, 500 bags	BAGGK10500	FALSE​
183.8​	#10 Paper Grocery Bag, 35lb White, Standard 6 5/16 x 4 3/16 x 12 3/8, 2000 bags	BAGGW10	FALSE​
69.9​	#10 Paper Grocery Bag, 35lb White, Standard 6 5/16 x 4 3/16 x 13 3/8, 500 bags	BAGGW10500	FALSE​
47.06​	#10 Paper Grocery Bag, 50lb Kraft, Heavy-Duty 6 5/16 x4 3/16 x13 3/8, 500 bags	BAGGH10500	FALSE​
56.13​	#10 Paper Grocery, 57lb Kraft, Extra-Heavy-Duty 6 5/16x4 3/16 x13 3/8, 500 bags	BAGGX10500	FALSE​
99.09​	#10 Paper Grocery, 60lb Kraft, Extra-Heavy-Duty 6 5/16x4 3/16 x12 3/8, 1000 bags	BAGGX10	FALSE​
777.77​	#10 Security Tint Business Envelopes with Redi-Seal® Closure, 100 per Box	QUA11217	FALSE​
10.53​	#10 Security Tint Business Envelopes with Redi-Seal® Closure, 100 per Box	QUA11217-BULK	TRUE​
777.77​	#10 Security Tinted Envelopes with Redi-Strip® Self Seal Closure, for Business Mailing, 24 lb White Wove, 4-1/8 x 9-1/2, 100 per Box	QUA69117	FALSE​
10.53​	#10 Security Tinted Envelopes with Redi-Strip® Self Seal Closure, for Business Mailing, 24 lb White Wove, 4-1/8 x 9-1/2, 100 per Box	QUA69117-BULK	TRUE​
57.21​	#10 Security Tinted V-Flap Business Envelopes, Gummed Flap, Great for High-Speed Inserting Equipment, White Wove, 500 per Box	QUA90012-BULK	TRUE​
54.72​	#10 V-Flap Business Envelopes, Gummed Flap, Great for High-Speed Inserting Equipment, White Wove, 500 per Box	QUA90010-BULK	TRUE​
87.32​	#10 Window Security Tinted V-Flap Business Envelopes, Gummed Flap, Great for High-Speed Inserting Equipment, White Wove, 500 per Box	QUA90013-BULK	TRUE​
76.46​	#10 Window V-Flap Business Envelopes, Gummed Flap, Great for High-Speed Inserting Equipment, White Wove, 500 per Box	QUA90011-BULK	TRUE​
89.26​	#12 Paper Grocery Bag, 35lb Kraft, Standard 7 1/16 x 4 1/2 x 12 3/4, 1000 bags	BAGGK12	FALSE​
122.94​	#12 Paper Grocery Bag, 35lb White, Standard 7 1/16 x 4 1/2 x 12 3/4, 1000 bags	BAGGW12	FALSE​
39.85​	#12 Paper Grocery Bag, 40lb Kraft, Standard 7 1/16 x 4 1/2 x 13 3/4, 500 bags	BAGGK12500	FALSE​
60​	#12 Paper Grocery Bag, 40lb White, Standard 7 1/16 x 4 1/2 x 13 3/4, 500 bags	BAGGW12500	FALSE​
49.03​	#12 Paper Grocery Bag, 50lb Kraft, Heavy-Duty 7 1/16 x 4 1/2 x 13 3/4, 500 bags	BAGGH12	FALSE​

 

[Fluff]

Does the other sheet exist? If so do you want to delete what's already there, or just add the new below existing data?
Also do you want to delete the data from that list?

 

[joeloveszoe]

the sheet does not exist yet

ultimately i am trying to separate the data

i start with 1 main spreadsheet

i want to separate into 2 spreadsheets
skus (ending with -BULK) with all info into 1 spreadsheet (or leave on starting)
and
skus (without -BULK) with all info into 2nd spreadsheet

in the paste sample above - these skus would be on separate spreadsheets
QUA11217
QUA11217-BULK

thanks!!!!

 

[Fluff]

Ok, how about

Sub joeloveszoe()
   Dim Ws As Worksheet, Nws As Worksheet
   
   Set Ws = ActiveSheet
   Set Nws = Sheets.Add(, Ws)
   Ws.Range("A1:D1").AutoFilter 3, "*bulk"
   Ws.AutoFilter.Range.Copy Nws.Range("A1")
   Ws.AutoFilter.Range.Offset(1).EntireRow.Delete
   Ws.AutoFilterMode = False
End Sub

 

[joeloveszoe]

hmmm, will have to google around to learn how to use VBA codes ... not currently in my skill set!
can you point me to a good tutorial?

thanks for the direction!

 

[Fluff]

You can do it manually by selecting the filter drop down, Text filters, Ends with, enter Bulk.
There are plenty of sites about VBA, but I have no idea how good any of the tutorials are.