Hi, I have two worksheets labeled Daily and Daily Report. I'm trying to filter the data from the Daily onto the Daily Report in order to generate a report to send out to my higher-ups.
So far I've used the advanced filter but I've noticed that it does not auto-update itself when I add more data to the Daily (we use this worksheet throughout the year and create a new one with the new year).
Is there a way to code it to automatically update itself when I add more data?
Thanks in advanced.
So far I've used the advanced filter but I've noticed that it does not auto-update itself when I add more data to the Daily (we use this worksheet throughout the year and create a new one with the new year).
Is there a way to code it to automatically update itself when I add more data?
Thanks in advanced.