I am looking to write a macro that will set up my pivot table with specific rows, columns and filters(This part I have). Then, if the pivot table contains a Priority section, I want to run one macro, and if it doesn't I want to run a different macro (let's call them macro1 and macro2). The priority data can either be there or not be there each time the macro needs to be run based on the data that week.
But then the tricky part is once I have the data I need from whatever macro is run, I need to take that data and calculate the trend when compared to what was found for last week's data. However, last week's data may or may not contain a priority section as well.
This has been giving my code some issues as currently I have been using range lookups due to my misconception that the positions would not change. Due to the fact the data position might change between weeks, I am not sure as to the ideal approach to handle this type of situation.
Thank you for your time in advance, I look forward to your replies.
But then the tricky part is once I have the data I need from whatever macro is run, I need to take that data and calculate the trend when compared to what was found for last week's data. However, last week's data may or may not contain a priority section as well.
This has been giving my code some issues as currently I have been using range lookups due to my misconception that the positions would not change. Due to the fact the data position might change between weeks, I am not sure as to the ideal approach to handle this type of situation.
Thank you for your time in advance, I look forward to your replies.