Advanced filtering based off of another file Vlookup

[ItalianPlatinum]

Hello - I have posted before but I am not getting any hits. so going to keep my problem brief and generic. Hopefully someone could lead me to an answer or refer me to a way to get there.

Existing Code: Will open another worksheet (CSV) and covert it to a format I need to upload. The data within that file has unique characters in column A. In my worksheet where I execute the code from has those same unique values in Column B but also has them grouped by Column A. And what I am looking to do is list out all of the Column A's I want to see in that upload.

Example below: (i only want my upload to show 10 records)

Book2
	A	B	C	D
1	Type	Unique Tag		For Export
2	AA	ABC1		AA
3	AA	BBB1		CC
4	AA	CCC1		EE
5	AA	DDD1
6	BB	ACD1
7	BB	ADD1
8	BB	AFF1
9	BB	AGG1
10	CC	LLL1
11	CC	LLL2
12	CC	LLL3
13	CC	YYY4
14	DD	UUU8
15	DD	PPP0
16	DD	MNM1
17	EE	AFD1
18	EE	DF21
Sheet2

 

[ItalianPlatinum]

The message is telling you what the error is.

It occurred because you did not use the latest posted macro.
I am guessing you pasted what you think changed in my latest code into your previous macro - that was dangerous

Use what I posted and amend the 2 lines that I marked with "amend" and then all should be fine. ?

Works great - i like how you made it force the file to be saved a certain way too. if I ever wanted to remove the human element and just have it auto save automatically i could just go back to your old code and remove the inputbox correct?

 

[Yongle]

Yes - you could do that