Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gbloemke

    Filter and Delete Rows

    Thanks to PHV as well!
  2. gbloemke

    Filter and Delete Rows

    [smile]Skip, you're my new hero. It all works, and I learned a lot as well. Thanks and have a great weekend. Greg
  3. gbloemke

    Filter and Delete Rows

    Okay Skip, that was awesome? It worked! You just showed me a new way to do this, and I will remember the whole "With ActiveSheet.UsedRange" simplier thought process for my next code! Thank you. Question, after this code runs, I get a pop-up dialog box that says "Delete entire sheet row?" and...
  4. gbloemke

    Filter and Delete Rows

    I am sorry, I mispoke. This code works fine for filtering the data. I want to delete all rows that meet the filter criteria. It's the code that comes next that I am struggling.
  5. gbloemke

    Filter and Delete Rows

    I use Excel 2010. I run VBA code on this one table everyday. I currently have to do it partly manually, because it deletes more rows than I want it to. My goal is to filter the spreadsheet using this criteria: Filter column 22 = "NEP", also filter column 16 = "Groom". Then, I wish to delete...
  6. gbloemke

    Use of Three filters and a Delete Rows VBA Code in Excel

    Sometimes, the answer is simple and right under my nose. You were right Skip. I was thinking far too complicated about VBA code on this one. Back to basics for me. Thank you, Greg
  7. gbloemke

    Use of Three filters and a Delete Rows VBA Code in Excel

    I have a spreadsheet with 7000 lines of data. I want to delete certain rows of data that meet criteria. I need to filter column V to see only a criteria of "NEP". I then want to filter column P to see only a criteria of "Groom". I then want to filter column G to see only a criteria of "ONSP*"...
  8. gbloemke

    Code to change dates based on weekend and holiday criteria

    Mintjulet, that link helped a lot. That, along with the post from zelgar, solved my issue. Thanks. I was able to find what I needed.
  9. gbloemke

    Code to change dates based on weekend and holiday criteria

    I have created a worksheet that shows dates in 2013 in Column A. I need VBA code that will subtract 3 days from that date and put the new date in Column B (this is a simple subtraction formula that I have already created). However, the tricky part is that if that new date falls on a Saturday...
  10. gbloemke

    Turn Off AutoFilters

    Skip, that worked great, and it was so soo simple! Thank you, Greg
  11. gbloemke

    Turn Off AutoFilters

    I have this VBA code to add/remove the autofilters, but it toggles back and forth, meaning that when I run it the first time, it adds autofilters, when I run the code again, it removes it, run it again, it adds it again, and so on. I want this code to only remove the autofilter from the...

Part and Inventory Search

Back
Top