I have been strugling for past several day trying to resolve this issue. Here is what I have and what's needed:
I've got about 20 Excel sheets that contain massive data (around 50K rows/sheet) that need to be filtered. The automatic filter has been applied so I can just pick data. Now, when I choose the data manually, it takes me up to two hours to get what I want. Now imagine if it should be done repeatedly...
I can't use macro for some items are as long as 800! characters (macros can work with 255 chars. per command at max.).
It seems logical to copy the "picking" process within the filter (not the result you get after picking) but I can't figure out how.
Does anybody have any ideas or suggestions, please?