Hello,
I currently have a pivot table in Sheet 1 with a filter in place that falls in cell A3. The listed values in that filter match a list that I have on Sheet 2 starting in cell A1. Is there a macro that can go down the list in Sheet 2 one by one and select that value in the filter? I would then want to copy and paste value that pivot and save that sheet as a separate file, then continue down the list until the end.
Is that possible? Any guidance is greatly appreciated!
I currently have a pivot table in Sheet 1 with a filter in place that falls in cell A3. The listed values in that filter match a list that I have on Sheet 2 starting in cell A1. Is there a macro that can go down the list in Sheet 2 one by one and select that value in the filter? I would then want to copy and paste value that pivot and save that sheet as a separate file, then continue down the list until the end.
Is that possible? Any guidance is greatly appreciated!