Split Pdf based on the string

[kumark1]

Hi All,

I need to split the Pdf based on the state code , all the state codes will be on a sheet based on the cells value for each cell it shall split the file .

Thanks in advance for any help.

Regards
Kumar

 

[ranman256]

so you mean:
get a state in the list
filter the data on that 1 state
print pdf
get next state?

 

[kumark1]

Sorry for the late reply.Ya its correct. i have a list of the state in one sheet it should read the PDF if that state is found then consolidate the particular state report into a single report. the PDF is some where around 1500 pages based on the states i should split it.