Advance filter automation in VBA

Hi,

Might be that is super obvious to fix this but I am a proper beginner at VBA hence I need help with this, please.
I am to set up a log which will be updated daily. There is column "A" for date which will be growing each day and will result in the same date appearing multiple times.
I need to create a summary on the same sheet based on the dates. So I thought I will use Advance Filter to copy the unique values from column A to column G, then take it from there.
Works well except that I need to make this automatic every time a new cell in column A is populated with new data. Here I thought VBA will help.

I put this together with my bf's (Google) help:

Please Login or Register  to view this content.

I have no errors on saving/closing the code, so assumed it works. But nope...Can someone help please?

Thanks
Eva

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

Copy to range should be single cell (i.e. header), since you are copying single column.

Try...

Please Login or Register  to view this content.

NOTE: Please update your post to nest your code in # code tag.

I need to make this automatic every time a new cell in column A is populated with new data

Take a look at the Worksheet_Change event to automate this.

No worries, glad to help.

If you have further questions don't hesitate to ask.

Thanks for rep+.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.