VBA required for Print As PDF through Filter in Loop and name the PDF as each filtered item

[piyushchandrakar]

want to get the Separate PDF by column 1 filter and separate pages in each pdf by column 2

Name the exported PDF as column 1 name

please suggest the code to get the desired result.

i am very new to VBA coding.

i am having data as below

DSO Name
Abhishek Jadhav	CORONA LED BULB 12W CDL B22
Abhishek Jadhav	LEDZ BULB 9W CDL B22
Abhishek Jadhav	LEDZ BULB 9W CDL B22
Abhishek Jadhav	Bajaj Platini PX7 500W Mixer grinder.
Abhishek Jadhav	Microwave Oven 2005 ETB
ABHISHEK KESHARWANI	200W 250V BC CL-NP
ABHISHEK KESHARWANI	EDGE 1200 mm Brown CF

<tbody>
[TD="class: xl66, width: 399"]Retailer Name[/TD]
[TD="width: 399"]Item_Name[/TD]
[TD="class: xl65, width: 112"]Purchased Times[/TD]
[TD="class: xl65, width: 77"]Amount[/TD]

[TD="class: xl66"]NARESH DAILY NEEDS[/TD]

[TD="class: xl65"]1[/TD]
[TD="class: xl65"]1607.22[/TD]

[TD="class: xl66"]NARESH DAILY NEEDS[/TD]

[TD="class: xl65"]1[/TD]
[TD="class: xl65"]660.84[/TD]

[TD="class: xl66"]SINHA ELECTRICALS[/TD]

[TD="class: xl65"]1[/TD]
[TD="class: xl65"]321.44[/TD]

[TD="class: xl66"]TIRUPATI AUTO & CYCAL[/TD]

[TD="class: xl65"]1[/TD]
[TD="class: xl65"]1547.66[/TD]

[TD="class: xl66"]TIRUPATI AUTO & CYCAL[/TD]

[TD="class: xl65"]2[/TD]
[TD="class: xl65"]9253.12[/TD]

[TD="class: xl66"]Aarya hardware & electrical pathariya[/TD]

[TD="class: xl65"]1[/TD]
[TD="class: xl65"]323.91[/TD]

[TD="class: xl66"]Aarya hardware & electrical pathariya[/TD]

[TD="class: xl65"]1[/TD]
[TD="class: xl65"]974.63[/TD]

</tbody>

[TABLE="width: 987"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]