+ Reply to Thread
Results 1 to 4 of 4

Move Table Row from Sheet1 to another Table on Sheet2 based on cell content

  1. #1
    Registered User
    Join Date
    02-05-2021
    Location
    Bloomington, IN
    MS-Off Ver
    365
    Posts
    2

    Move Table Row from Sheet1 to another Table on Sheet2 based on cell content

    I have looked at several similar requests and can't seem to find a solution that I understand and can implement.

    I take in requests for access to systems and verify proper training prior to submitting the request for action. The 3 types of Status for a request are: Training, Work Order, and Complete (Column P).
    When the Status is changed to Complete on the "Open Requests" sheet, I want to move the request(s) to another sheet ("Completed Requests") to archive the requests at the push of a button (to reduce the chance of human error and data loss).

    Can anyone assist me with a solution? Thank You,
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Move Table Row from Sheet1 to another Table on Sheet2 based on cell content

    Try this

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    02-05-2021
    Location
    Bloomington, IN
    MS-Off Ver
    365
    Posts
    2

    Re: Move Table Row from Sheet1 to another Table on Sheet2 based on cell content

    What an amazingly compact piece of code! It does exactly what I needed. Thank you so much for your assistance.

  4. #4
    Registered User
    Join Date
    08-12-2019
    Location
    UK
    MS-Off Ver
    2016
    Posts
    6

    Re: Move Table Row from Sheet1 to another Table on Sheet2 based on cell content

    Good evening Vraag en antwoord,

    I just found your code after a site search and it works wonderfully for me in a similar situation to that of Penticuf's. I just had to change the cell references and it works perfectly!

    For the sake of better understanding the code, could you please explain this line of code:-


    Please Login or Register  to view this content.
    and what does the 2 signify.

    Thank you for this. You've saved me a considerable amount of time.

    Best regards,
    Leela.

+ 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. Move rows from sheet1 to sheet2 based on a field value
    By ivanka2000 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-19-2016, 08:15 AM
  2. Need help - macro filter cell value sheet1 in table sheet2
    By GoldbergJesse in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-19-2015, 03:43 PM
  3. move data from sheet1 to sheet2 based on date in column1 of sheet1
    By pcaldwell in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-10-2014, 03:20 PM
  4. macro to copy table from sheet1 to sheet2 (# of rows in table may vary everytime)
    By arkharova.s in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-18-2014, 03:18 AM
  5. Move cell values from sheet1 to sheet2
    By Aderk in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-25-2013, 04:48 PM
  6. Replies: 5
    Last Post: 12-19-2012, 11:05 AM
  7. [SOLVED] Move data from SHEET1 to SHEET2 based on Selected criteria...like an adv filter
    By gspivey79 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-03-2012, 02:06 PM

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