Copy range based on criteria in column - macro

[doriannjeshi]

Hi,
how to copy the entire data only for "male" to a new sheet named "male" , also for female. Using a macro

Book2
	A	B	C	D	E	F
1	id	first_name	last_name	email	gender	ip_address
2	1	Rikki	Pere	rpere0@alexa.com	Male	61.164.210.42
3	2	Vick	Ambrozik	vambrozik1@google.it	Male	102.222.176.131
4	3	Kali	Shelton	kshelton2@slate.com	Bigender	209.89.60.163
5	4	Lodovico	Shears	lshears3@bandcamp.com	Male	175.100.178.34
6	5	Rhoda	Gavaran	rgavaran4@alexa.com	Female	131.26.160.86
7	6	Gerri	Neale	gneale5@independent.co.uk	Male	76.95.229.131
8	7	Tod	Emmitt	temmitt6@dot.gov	Male	249.234.72.77
9	8	Killy	Louys	klouys7@networksolutions.com	Male	226.205.57.155
10	9	Johnna	Manlow	jmanlow8@freewebs.com	Female	66.160.3.172
11	10	Shandeigh	Possell	spossell9@blogspot.com	Female	54.79.95.159
12	11	Thelma	Corballis	tcorballisa@mediafire.com	Female	209.246.69.109
13	12	Christabella	McCowan	cmccowanb@skyrock.com	Female	254.29.4.81
14	13	Tristan	Stede	tstedec@weibo.com	Male	58.238.118.14
15	14	Klara	Storres	kstorresd@parallels.com	Female	103.61.128.129
16	15	Bendix	Cavnor	bcavnore@addthis.com	Polygender	115.197.228.198
17	16	Pammi	Whiles	pwhilesf@archive.org	Female	235.85.253.158
18	17	Sena	Fothergill	sfothergillg@indiatimes.com	Female	121.116.167.159
19	18	Ofelia	Sargison	osargisonh@uiuc.edu	Female	30.29.132.119
20	19	Oberon	End	oendi@dedecms.com	Male	19.176.34.160
21	20	Caresa	Kybbye	ckybbyej@a8.net	Agender	157.221.2.249
22	21	Saundra	Yelding	syeldingk@reddit.com	Male	240.178.148.42
23	22	Daisy	Parnell	dparnelll@home.pl	Female	5.136.226.91
24	23	Prue	Corran	pcorranm@istockphoto.com	Female	16.235.134.99
25	24	Gamaliel	Moysey	gmoyseyn@t-online.de	Male	56.38.94.245
26	25	Pebrook	Quinion	pquiniono@naver.com	Male	88.85.159.192
27	26	Douglass	Rossi	drossip@yahoo.co.jp	Male	20.52.3.13
28	27	Kayne	Merton	kmertonq@fotki.com	Male	228.35.108.191
29	28	Oona	Biddlestone	obiddlestoner@trellian.com	Female	25.80.120.56
30	29	Theadora	Blacktin	tblacktins@jimdo.com	Female	7.174.1.190
31	30	Phelia	Rykert	prykertt@ning.com	Female	128.142.83.253
Sheet1

result

Book2
	A	B	C	D	E	F
1	id	first_name	last_name	email	gender	ip_address
2	1	Rikki	Pere	rpere0@alexa.com	Male	61.164.210.42
3	2	Vick	Ambrozik	vambrozik1@google.it	Male	102.222.176.131
4	4	Lodovico	Shears	lshears3@bandcamp.com	Male	175.100.178.34
5	6	Gerri	Neale	gneale5@independent.co.uk	Male	76.95.229.131
6	7	Tod	Emmitt	temmitt6@dot.gov	Male	249.234.72.77
7	8	Killy	Louys	klouys7@networksolutions.com	Male	226.205.57.155
8	13	Tristan	Stede	tstedec@weibo.com	Male	58.238.118.14
9	19	Oberon	End	oendi@dedecms.com	Male	19.176.34.160
10	21	Saundra	Yelding	syeldingk@reddit.com	Male	240.178.148.42
11	24	Gamaliel	Moysey	gmoyseyn@t-online.de	Male	56.38.94.245
12	25	Pebrook	Quinion	pquiniono@naver.com	Male	88.85.159.192
13	26	Douglass	Rossi	drossip@yahoo.co.jp	Male	20.52.3.13
14	27	Kayne	Merton	kmertonq@fotki.com	Male	228.35.108.191
male

 

[doriannjeshi]

This has not been mentioned before. Just as Married was not mentioned at the start.
You need to specify your requirements (all of them) at the beginning rather than getting an answer and then changing the requirement continually.

You are right, I apologise I added a request after the original post

about the second request I was sure I could modify the macro to include more than 2 criteria in one sheet, my bad

 

[Peter_SSs]

OK, lets start afresh. With XL2BB can you give some new (small) sample data, explain all of exactly what you want & also provide the expected results?

 

[doriannjeshi]

Yes, at this point I just need to have the macro that puts all the months that I can specify to a NEW sheet named "months"

Book2
	A	B	C	D	E	F
1	A	B	C	D	E	F
2	june	3			-3	1
3	june	3	1	1	1	1
4	april	3	1		1	1
5	may	3	1	1	1	1
6	february	3	1	1
7	october	3	1	1
8	october	3	1	1
9	november	3	1	1
10	december	3	1	1
11
12
13	result
14	A	B	C	D	E	F
15	june	3			-3	1
16	june	3	1	1	1	1
17	may	3	1	1	1	1
18	october	3	1	1
19	october	3	1	1
20	sheet name"months"
sheet12

 

[Peter_SSs]

Yes, at this point I just need to have the macro that puts all the months that I can specify to a NEW sheet named "months"

That seems to have absolutely nothing to do with the rest of this thread?

 

[doriannjeshi]

Yes, this scenario needs own thread as everything else was solved in this thread

thank you Peter and Mark