I tried using the code in your tutorial with a data table I am working with and did not work. This is my first attempt at using a macro to automate anything in excel so I am sure I am doing something wrong. I tried running in step and it highlights the Sub line. The table I am working with has order entries each listing the operations associated with these orders. Several operations in some orders do not have a scheduled start date, which is essential for the project I am doing so I need to delete the rows missing the start date and any operations associated with the order that had a "defective" operation. From your video I got the impression that your script would do this task but I can't make it work. Any advice?
Hey! Apologies for the late response. Hope you were able to figure it out, but if not, you can try this video to delete only rows with missing dates and then work up from there: th-cam.com/video/Waa7Ew2n6T0/w-d-xo.htmlsi=Sc7T1R2SJIuj-Ww8 hope it helps!
Sorry to hear it didn't work for you! Could you share a bit more detail about the issue you're experiencing? I'd be happy to help troubleshoot and see if we can get it working. Appreciate your feedback
Oh you're back
😎😎
Your tutorials are really great and super useful 👌I can see a lot of use cases for this specific example in a lot of real world scenarios
Thanks! Appreciate the feedback as always!!
I tried using the code in your tutorial with a data table I am working with and did not work. This is my first attempt at using a macro to automate anything in excel so I am sure I am doing something wrong. I tried running in step and it highlights the Sub line.
The table I am working with has order entries each listing the operations associated with these orders. Several operations in some orders do not have a scheduled start date, which is essential for the project I am doing so I need to delete the rows missing the start date and any operations associated with the order that had a "defective" operation. From your video I got the impression that your script would do this task but I can't make it work.
Any advice?
Hey! Apologies for the late response. Hope you were able to figure it out, but if not, you can try this video to delete only rows with missing dates and then work up from there: th-cam.com/video/Waa7Ew2n6T0/w-d-xo.htmlsi=Sc7T1R2SJIuj-Ww8 hope it helps!
Did not work, two thumbs way down
Sorry to hear it didn't work for you! Could you share a bit more detail about the issue you're experiencing? I'd be happy to help troubleshoot and see if we can get it working. Appreciate your feedback