Results 1 to 5 of 5

Macro required to move row from one worksheet to another based on cell value

Threaded View

  1. #1
    Registered User
    Join Date
    10-16-2014
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    8

    Macro required to move row from one worksheet to another based on cell value

    Hi

    I am trying to find the correct macro to allow rows in my worksheet to be moved to another worksheet based on the value in column K which is 'status'. I would like the row to be completely removed from Worksheet 1 and entered into the next available line in the required worksheet.

    I have three worksheets and initially all data is entered into Worksheet 1 "Open". Once the row 'STATUS' (column K) is changed to 'closed' or 'tender' i would like to have the entire row removed to the appropriate worksheet (Worksheet 2 "Closed" or Worksheet 3 "Tender").

    Also (though not important) I would like to be able to have the rows moved back to the "OPEN" worksheet if the status is changed from closed/tender to 'open'.

    I have played around with a few different marco options but cant seem to find the right formula.

    Example worksheet attached.

    Any help is appreciated!
    thanks
    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. Macro - move files to folder based on list in worksheet
    By uncleslinky in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-03-2015, 05:57 PM
  2. Move cells based on cell length *shift cells right) - code required
    By pauldaddyadams in forum Excel Programming / VBA / Macros
    Replies: 49
    Last Post: 11-21-2014, 08:56 AM
  3. [SOLVED] Move row to another worksheet based on cell value
    By RTFAchllesi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-03-2014, 11:22 PM
  4. VB Code required to move macro to next row down cell
    By Jackt90 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-18-2014, 11:01 AM
  5. Move Row To Another Worksheet Based On A Cell Value
    By klk300 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 11-28-2012, 10:58 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1