Hi all,
Greatly appreciate if someone can help me with writing this macro as this is way beyond my limited vba skills. I have attached a simplified version of the excel file.
I have a pivot table within an Excel file that shows product numbers and the associated price and date/time information for each product based on a list which can change each month.
I need a macro to do the following:
1. Automatically filter the pivot table to show the information for 1 product at a time based on the required list at cell B13:B14 (this list is subject to change each months).
2. Save the resulting Report table (with the filter on) from cell F5 to M12 to a PDF file.
3. Apply the filter to the next vendor number (cell B1) ...and so on until I have 1 PDF file created for each product.
4. And automatically save the pdf files with their respective product number as the file name.
Many thanks in advance.
iceblocks
Greatly appreciate if someone can help me with writing this macro as this is way beyond my limited vba skills. I have attached a simplified version of the excel file.
I have a pivot table within an Excel file that shows product numbers and the associated price and date/time information for each product based on a list which can change each month.
I need a macro to do the following:
1. Automatically filter the pivot table to show the information for 1 product at a time based on the required list at cell B13:B14 (this list is subject to change each months).
2. Save the resulting Report table (with the filter on) from cell F5 to M12 to a PDF file.
3. Apply the filter to the next vendor number (cell B1) ...and so on until I have 1 PDF file created for each product.
4. And automatically save the pdf files with their respective product number as the file name.
Many thanks in advance.
iceblocks
