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 derfloh 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. djkeller

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

    Works perfectly. Thanks for all your help!
  2. 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
  3. 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...
  4. 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...
  5. 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