+ Reply to Thread
Results 1 to 5 of 5

Moving entire rows

  1. #1
    Registered User
    Join Date
    10-16-2012
    Location
    Guelph, Canada
    MS-Off Ver
    Excel 2003
    Posts
    26

    Moving entire rows

    Hello,
    I have code that checks to see if a cell has a certain work in it, and if it does it writes that word in a cell in another sheet, then moves to the next cell down and does the same thing. I use this code:
    Please Login or Register  to view this content.
    This code writes "call" in A1(sheet 5) if A1(Sheet4) has "Call" in it. My problem is that i want to move then entire row if A1 says "call". I want to do this because the rest of the row has other info that i want to move over to sheet5. If there is a way to alter this code to do that, that would be great a new subroutine would be great too tho.

    Thanks :D

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Moving entire rows

    Please Login or Register  to view this content.
    If solved remember to mark Thread as solved

  3. #3
    Registered User
    Join Date
    10-16-2012
    Location
    Guelph, Canada
    MS-Off Ver
    Excel 2003
    Posts
    26

    Re: Moving entire rows

    Sorry, but this just moves "Call" to ever cell in the row. What i need is something that takes a look at an entire row, and if the first cell in that row conatins "Call", move the entire row to the other sheet.

  4. #4
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Moving entire rows

    attach a sample file, this code works on my testfile

  5. #5
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Moving entire rows

    Hi,patel45,

    I doubt that your code will ever move a row from one sheet to another - not even in your workbook.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1