Hi
currently I have a spreadsheet with 30,000+ rows. I use the following code to delete rows that contain the value "A" in the Code column and also the value "sc" in another column. However, it takes 10min+ to run. I am wondering if there is a way to speed this up?
Please Login or Register to view this content.
you can use autoFilter
Please Login or Register to view this content.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Maybe this could help.
It sorts the data ascending on column E, filters for "A" then deletes them. Repeat for column G. You may want to add a final sort to make your data back in original sorting, maybe on column A, I am not sure.Please Login or Register to view this content.
多么想要告诉你 我好喜欢你
works perfectly, thanks to you both
I also have a column with venues that I use to do a vlookup to a list of venues, then if the venue is found, it deletes the row. This also takes a huge amount of time. Is there a way to speed this up also?
Please Login or Register to view this content.
the the vlookup seperately once then filter and delete
here is the vlookup part
Please Login or Register to view this content.
thank you but I am having trouble deleting the rows. The vlookup returns 1 or the name of the venue. I tried using <> 1 but it doesn't work. I am having trouble with the line in bold. Do you know how I can fix this?
Please Login or Register to view this content.
I did not autofilter, I have it now. Thanks
you left out the autofilter part
Please Login or Register to view this content.
This might be a tad faster:
Please Login or Register to view this content.
that is so much faster! Thank you to you both!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks