Clean Data with ChatGPT: Create and Refresh Pivot Table with VBA

hi after 5 years, i again come back to ur videos for solution. i lost the code once i created at that time and now i am searching out how i have did that. what i am trying to do is.. first filtering the row on basis of certain cell, after that automatically save to pdf keeping the file name same as the filtered data cell value. and continue till the last row.. can you help