I will start off by saying I'm no prodigy when it comes to excel, in fact, I'm more like the prodigies long lost second cousin that's been twice removed from the family who everyone avoids because they have a weird fascination with spoons. What I've learnt so far has helped a great deal, however somethings still elude and confuse me.
For instance, I have a pivot table based off of automatically acquired data from a source. I want this pivot table to only show the most recent month in the data but without any human interaction, I also want this to update anytime a new information is added to the source. Is this possible? If not, perhaps there is another way to obtain this information?
Thank you for your time,
Allan.T
For instance, I have a pivot table based off of automatically acquired data from a source. I want this pivot table to only show the most recent month in the data but without any human interaction, I also want this to update anytime a new information is added to the source. Is this possible? If not, perhaps there is another way to obtain this information?
Thank you for your time,
Allan.T