Results 1 to 28 of 28

VBA code to move entire row based on value/s from input box

Threaded View

  1. #1
    Registered User
    Join Date
    05-17-2020
    Location
    Philippines
    MS-Off Ver
    2016
    Posts
    35

    VBA code to move entire row based on value/s from input box

    Hi!

    I would like to ask help on a VBA code to help me move an entire row to another worksheet based on a value (or multiple values) from an input box. For example I have a list of employees and I want to move one or several of them to the terminated sheet without going through the list one by one or searching by ctrl + F and then cut and paste to the terminated tab. I would like to have an input box where I can just put the employee id (or employee id's of there are more than one) and then it will find the employee from the active employees tab, cut the row and paste it to the terminated tab.

    I have attached a sample file.

    Your help is greatly appreciated!

    Regards,
    Roux11
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Noob in need of VBA code to move entire row based on cell criteria
    By missmlsaz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-10-2019, 02:04 PM
  2. Move entire row of data to another worksheet based on a value
    By tjsmith1962 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-11-2018, 03:53 PM
  3. Move entire row from one sheet to another based on cell input
    By ChristianJ in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-01-2018, 11:31 PM
  4. Replies: 3
    Last Post: 01-01-2016, 04:07 AM
  5. Move an entire row to a new sheet based on the value of a cell.
    By jgroathouse in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-05-2014, 08:16 PM
  6. [SOLVED] Move entire row to another worksheet based on cell value
    By bdf0827 in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 04-09-2014, 07:01 AM
  7. Move entire row to a new sheet based on cell value vba help
    By almasdour in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-15-2013, 01:38 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