+ Reply to Thread
Results 1 to 2 of 2

Formula or Macro to Move Rows From Sheet 1 to Sheet 2 in Same Workbook

  1. 09-01-2017, 10:25 AM #1
    singerr45
    singerr45 is offline
    Registered User
    Join Date
    03-01-2016
    Location
    New York
    MS-Off Ver
    Office 2016
    Posts
    13

    Formula or Macro to Move Rows From Sheet 1 to Sheet 2 in Same Workbook

    I'm working in google sheets for this project and am looking for a formula or macro or perhaps a google script to automatically move an entire row and the row below it from sheet 1 to sheet 2. Essentially I have a list of data in sheet 1 that has all of my upcoming work. Once I have finished my work on each project I mark Row L with a "Y".

    Is there any way to move the entire row and the row below it once Row L has been marked with "Y" in Sheet 1 over to Sheet 2?
    Last edited by singerr45; 09-01-2017 at 11:43 AM.
    Reply With QuoteRegister To Reply
  2. 09-03-2017, 02:31 PM #2
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Formula or Macro to Move Rows From Sheet 1 to Sheet 2 in Same Workbook

    You can cut & paste
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macros To Move Multiple Rows To Another Sheet And Macro To Move Single Rows To DAX Table
    By jcaynes in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-22-2013, 05:08 PM
  2. [SOLVED] macro to copy rows from a sheet in one workbook to a sheet in a different workbook...
    By fredderf81 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-16-2013, 01:36 PM
  3. Move rows with certain value to separate sheet within the workbook
    By KateM in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-27-2013, 01:14 PM
  4. Macro to move rows from one sheet to another sheet based on a cell vaule
    By d55272 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 10-09-2012, 03:33 PM
  5. Move data rows from multiple sheets to a master sheet in another workbook
    By Nick_WBA in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-14-2012, 03:28 PM
  6. Need macro to move from sheet to Workbook
    By anee5252 in forum Excel General
    Replies: 15
    Last Post: 05-02-2012, 10:41 AM
  7. Clear out all rows and move them to a corresponding sheet on the same workbook
    By ldorsi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-21-2011, 01:13 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1