Hi Guys,
I have a spreadsheet which maintains log of all errors we get on daily basis. For reporting purpose we group them by week # / Month and YTD and generates some stats. My problems is that the month and week # is constantly moving depending on when the report is refreshed. I have written a macro which will refresh the pivot each time they want an updated report but the problem is I want the macro to pick up the latest (or Highest) week / month in data range rather then setting the filter to pick this week or month manually....?????
Cheers,
I have a spreadsheet which maintains log of all errors we get on daily basis. For reporting purpose we group them by week # / Month and YTD and generates some stats. My problems is that the month and week # is constantly moving depending on when the report is refreshed. I have written a macro which will refresh the pivot each time they want an updated report but the problem is I want the macro to pick up the latest (or Highest) week / month in data range rather then setting the filter to pick this week or month manually....?????
Cheers,
