Results 1 to 11 of 11

Cut and Paste row range based on active cell condition to another sheet

Threaded View

  1. #1
    Registered User
    Join Date
    08-19-2013
    Location
    Detroit, MI
    MS-Off Ver
    Excel 2003
    Posts
    6

    Cut and Paste row range based on active cell condition to another sheet

    Hi,

    I would like a vba code to cut the current row range based on the active cell if the user select "Yes". The cell is a dropdown with "Yes or No". The user would then be able to paste to a different sheet called "Complete".

    I got this code but stuck. If anyone could help I appreciated it.

    Public Sub CopyCurrent()
      If Application.IsText(ActiveCell.Value) = "Yes" Then
    
    Rows(ActiveCell.Row).Select
    
     Else
     End If
    End Sub
    See my attached file.

    thanks
    Hugh
    Attached Files Attached Files
    Last edited by Fotis1991; 10-07-2013 at 07:29 AM. Reason: code tags are added

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy Cell Range From Previous Sheet and Paste to Active Sheet
    By jtal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-01-2013, 03:26 PM
  2. Copy-Paste range based on condition
    By Link in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-06-2011, 01:10 PM
  3. Copy/Paste from one sheet to another based on condition
    By TheTempest in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-16-2010, 01:13 PM
  4. Finding a named range based on cell value and copy/paste to same sheet?
    By Simon Lloyd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-11-2006, 06:25 PM
  5. [SOLVED] Copy from active sheet and paste into new sheet using info from cell in active
    By Ingve in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-23-2006, 06:00 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