Hi guys,
I have report with new data every day. every day I am filtering it to different sheets in order to be able to work with it.
I want to make a template using VBA, that will allow me to enter new data every day and just click a button which will sort it the way I need.
I tried to use advanced filtering and recording it. Once recorded I added a button on the first sheet and assigned it to the recorded macro.
However, when I click the button (without even changing the data- it is still the same data that was recorded), I get the following error:
Run-time error '1004':
The extract range has a missing or illegal field name
I know it is an error that the advanced filtering gives when I have a problem with the range to where I want to copy. But I don't understand why I get this error.
Attaching my attempt.
Thanks,
Niuk
Bookmarks