Thank you so much Greg for the valuable tutorial, sharing the code, especially the clear video. Thumb up 👍
@alexrosen8762
Жыл бұрын
You deliver great stuff man 👏💪👏
@greggowaffles
Жыл бұрын
Thanks 💪😎
@nullhas
Жыл бұрын
Fantastic Greg. How we can use this to delete rows (if a column contains duplicate email id or mobile number)?
@greggowaffles
Жыл бұрын
Thanks! Do you have a specific example?
@nullhas
Жыл бұрын
@@greggowaffles Yes…let me know how can I share?
@raeaustin
Жыл бұрын
Is it possible to delete everything that doesn't match cell B1? In the example, hostname would be in B1. If InStr(my_string, "if it matches B1") = 0 _
@judahlee7837
Жыл бұрын
Hi Greg, how do I delete rows if cell contains a Certain Time Value???
@odijin
Жыл бұрын
Holy moly!!! This is awesome! Thanks very much for sharing your excel skills with this video. I learned a bunch. This video is particular useful for me because it shows how to loop through certain values in cells and than calls for an action. I have a slightly different scenario and wanted to ask your help. I have an excel file with multiple sheets like 100+ sheets, and I want to look for a value in each of those sheets and once that value is identified, is there a way to delete that sheet or sheets altogether? For example, if I used your codes in this video to loop through all the sheets searching for a specified value/string in a call in each of the sheets, then how can I delete all the sheets that contain that value? Thanks for the knowledge!!
@greggowaffles
Жыл бұрын
Thanks! Would this value be found in any column on any sheet, or are we looking at the same column across all sheets?
@odijin
Жыл бұрын
@@greggowaffles Thank you for the response. To answer your question, this value would be found in the same column and row in all the sheets. So for example in every sheet if cell A1 has the string "Turtle Soup" then that entire sheet should be deleted, and it loops through all the sheets looking for turtle soup in cell A1 and deletes any sheets containing that value. Hope my explanation helps. And again, thank you so much for your guidance!!!!!
@greggowaffles
Жыл бұрын
@@odijin thanks for clarifying! I’ll drop a video on that tomorrow!
@odijin
Жыл бұрын
@@greggowaffles looking forward to your video! much appreciations.
Пікірлер: 24