Hi all,
My basic problem is this: I often filter data and am then interested in compiling statistics or other stuff on this data. This can't be done using ordinary Excel formulas. So, my approach have been copy and paste filtered data to a new sheet. This is time consuming.
With some online sample code, I was able to create a macro which copies my filtered data to a new similar table.
Further, using the Macro Recorder, I was also able to create a macro which deletes the filtered data as the macro above does not clear the table first. I can live with that.
Can I ask some of you guys kindly to take a look and see if this seems okay/correct? Or if there's something that could be done better?
I made a few tests already and it does seem to work correcly.
Thanks in advance!
Best regards.
Elijah
Bookmarks