Hello can anybody help me with a problem when using the pivot table. On the report sheet you have a drop down section which let's you see which info you want to select. How do you stop it logging old date from a week ago. Because in one section i must have 200+ ref numbers and 99% i don't use anymore.
How can you stop it doing this
Many thanks