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 bkrike 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: *

  • Users: gbloemke
  • Content: Threads
  • Order by date
  1. 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...
  2. 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*"...
  3. 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...
  4. 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