+ Reply to Thread
Results 1 to 10 of 10

Move whole row of data to different worksheet if first cell in row = s

  1. #1
    Registered User
    Join Date
    08-02-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    4

    Move whole row of data to different worksheet if first cell in row = s

    I would like to move the current row of data to another sheet when I change a value in the row from an x to an s. I think I could use an If statement, but if you can move data from one worksheet to another, I don't know the syntax to use.

    thank you for your help

    Gwen

  2. #2
    Forum Contributor
    Join Date
    07-24-2012
    Location
    Brentwood, TN
    MS-Off Ver
    Excel 2007 at home/2010 at work
    Posts
    228

    Re: Move whole row of data to different worksheet if first cell in row = s

    I don't know how to do that with formulas. But I can do it with a macro and you can insert a button. Maybe someone else will know how to do it and can post on here if they do, unless you are comfortable with using a button attached to a macro, after changing your x's to s's.

  3. #3
    Forum Contributor
    Join Date
    08-02-2013
    Location
    Wageningen, The Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    493

    Re: Move whole row of data to different worksheet if first cell in row = s

    the syntax for referring to another sheet, let's say cell A1 in sheet2, is sheet2!A1

    is that what you need?

    if you need help with your if-statement (it's possible without macro's) let me know
    Last edited by L-Drr; 08-02-2013 at 06:07 PM.
    When I say semicolon, u say comma!

  4. #4
    Registered User
    Join Date
    08-02-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Move whole row of data to different worksheet if first cell in row = s

    L-Drr

    It's the If statement I need help with.

    thanks!

  5. #5
    Forum Contributor
    Join Date
    08-02-2013
    Location
    Wageningen, The Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    493

    Re: Move whole row of data to different worksheet if first cell in row = s

    Ok here's my interpretation of your problem:

    Cell A1 in Sheet1 contains the x that you might change to an s and below are the values that should be copied.
    In column A of Sheet2 you want the data to be copied into.

    Select in Sheet2 cell A1 (or A2) and type: =IF(Sheet1!A$1="s";Sheet1!A2) and click-drag this downwards.
    Is that what you need?

  6. #6
    Registered User
    Join Date
    08-02-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Move whole row of data to different worksheet if first cell in row = s

    L-Drr

    You have it all right except I need the whole row to move to sheet 2. Using the formula you listed only copies one cell to sheet 2. I need it to move/cut the whole row.

    Do you know of a way to do that?

    thank you!

  7. #7
    Forum Contributor
    Join Date
    08-02-2013
    Location
    Wageningen, The Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    493

    Re: Move whole row of data to different worksheet if first cell in row = s

    Ah. That does require macro's, hold on I'll give it a try.
    BTW if it only copies one cell, I think you have forgotten to click-drag?

  8. #8
    Forum Contributor
    Join Date
    08-02-2013
    Location
    Wageningen, The Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    493

    Re: Move whole row of data to different worksheet if first cell in row = s

    I gave it a try but I didn't get very far. This is what I have so far:

    Please Login or Register  to view this content.
    There are still things missing in this code, though. If you move your thread to the Excel Programming / VBA / Macros section, I'm sure there are people there that can help you. Sorry I couldn't help you any further.

  9. #9
    Registered User
    Join Date
    08-02-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Move whole row of data to different worksheet if first cell in row = s

    L-Drr

    thank you! I will work with this code for awhile and see what I can do.

    Gwen

  10. #10
    Registered User
    Join Date
    01-02-2014
    Location
    Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Move whole row of data to different worksheet if first cell in row = s

    I have excel sheet with name "DB" and second sheet name is "OldDB" now want to move entire rom on "oldDB" when I write In-activein first coloum. Please help me. I am using 1 macro but giving some error.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need to move data that matches criteria in cell and move to new worksheet
    By panagle in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-27-2013, 09:23 AM
  2. Replies: 1
    Last Post: 02-14-2012, 07:00 AM
  3. Move data to matched cell on dif worksheet
    By bhodge10 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2009, 02:26 PM
  4. How do I move certain Cell data from one worksheet to another?
    By ryan r in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-20-2005, 06:05 PM
  5. Move cell data to another worksheet cell automatically.
    By Alan in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 10-09-2005, 07:05 PM

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