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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by cclgroup

  1. cclgroup

    Deleting Rows

    So this is what i have so far...im not sure if it makes sense where i'm stuck is actually deleting the line that doesn't meet the criteria....
  2. cclgroup

    Deleting Rows

    Sub delete() Sheets("866").Select Dim fee1 As Integer Dim fee2 As Integer Dim fee3 As Integer Dim fee4 As Integer Dim fee5 As Integer Dim c As Range fee1 = Sheets("Sheet1").Range("a1").Value fee1 = Sheets("Sheet1").Range("a2").Value fee1 = Sheets("Sheet1").Range("a3").Value fee1 =...
  3. cclgroup

    Deleting Rows

    Hi, I'm having trouble deleting rows based on a certian criteria. I have two sheets in workbook. One has a list of all the diferent criteria I need and the other sheet has a tonnes of rows of data. I want to delete all the rows which don't have the crietia from the first sheet. The criteria...
  4. cclgroup

    Excel Macro

    Thanks! I made the change and now the code doesn't produce any errors...but it still doensn't select the whole range. Only the first row gets copied and pasted...is there a way around that?
  5. cclgroup

    Excel Macro

    Hey I'm trying to create a macro which searches for a certain range and then copies and pastes it into a new sheet. The problem i'm having is finding and defining the range. The range starts with a portfolio code and end with that same portfolio code; and I want to select everything in between...
See more

Part and Inventory Search

Back
Top