Hi jindon, and excel friends!
I'm trying to slightly modify this macro to have like 15 more columns like date (column C), that also transfer to the new worksheet.
I modifyied the code, and it works with my sample, but when I apply it to my actual dataset, with 17,000+ rows, I get an error.
Run-time error '1004':
Application-defined or object-defined error
When when I go to the debug,I get a yellow highlight in the 4th to last line of the code (".Value = b")
Here is the code I've slightly modified to include all the additional columns I want to keep.
Bookmarks