HI,
Is there any excel formula , which can help my pivot table to refresh with the new data we pasted and automatically get updated with the current month as well.
Like as attached sheet , where my data is updated with month 3 but in pivot table it is 2…..i want some formula which automatically update it to 3 and so on.
Thanks in advance
Is there any excel formula , which can help my pivot table to refresh with the new data we pasted and automatically get updated with the current month as well.
Like as attached sheet , where my data is updated with month 3 but in pivot table it is 2…..i want some formula which automatically update it to 3 and so on.
Thanks in advance