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!

  • Congratulations derfloh 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 djkeller

  1. djkeller

    Move row in Excel to another sheet based on a number entered

    It is giving me a message Run Time Error '1004' PasteSpecial method of Range class failed and highlighting line Sheets("Inactive").Cells(2, 1).End(xlDown).Offset(1).PasteSpecial xlPasteAll
  2. djkeller

    Move row in Excel to another sheet based on a number entered

    Columns("A:A").Select Selection.Find(What:="30334495", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate Rows("413:413").Select Selection.Cut...
  3. djkeller

    Move row in Excel to another sheet based on a number entered

    Skip, I'd agree. I'm just another sales rep here, but I quickly fell into a position where I've been helping a lot of people out with their computer issues. I inherited this list as an Excel file. I think this should eventually go into an Access program, but that's a whole other project...
  4. djkeller

    Move row in Excel to another sheet based on a number entered

    I have an Account Contact Management Excel workbook with multiple sheets for different sales reps. I want to find a way to write a code that when a rep would like to move an account into the "Inactive" tab. Each row in the sheet corresponds to one account contact. I'm imagining a button that...

Part and Inventory Search

Back
Top