Results 1 to 2 of 2

Create a macro to copy data from one worksheet to another worksheet based on criteria met

Threaded View

Wombat62 Create a macro to copy data... 03-14-2017, 09:17 PM
AliGW Re: Create a macro to copy... 03-15-2017, 09:44 AM
  1. #1
    Registered User
    Join Date
    03-14-2017
    Location
    KIAMA, AUSTRALIA
    MS-Off Ver
    OFFICE 13
    Posts
    1

    Create a macro to copy data from one worksheet to another worksheet based on criteria met

    I have a button that when selected an excel macro runs that if you have highlight a row in "DAILY CONTROL" worksheet this will cut this data and place it where the current selected cell position in "COMPLETED" worksheet.

    Sub COMPLETED()
    '
    ' COMPLETED Macro
    ' 
    
    '
        Sheets("COMPLETED").Select
        ActiveSheet.Paste
        Sheets("DAILY CONTROL").Select
        Application.CutCopyMode = False
        Selection.Delete Shift:=x1up
        ActiveWindow.SmallScroll Down:=-3
        
    End Sub
    What I am trying to do is change the macro to automate this so that any row in DAILY CONTROL worksheet that has text = COMPLETED in column H will then copy the data from columns A:K to the next blank row in COMPLETED worksheet A:K.
    I then go back into the DAILY CONTROL worksheet and clear the contents, except for columns D & H of these rows which have formula's that I don't want removed.
    I have up to 1000 rows and wish to keep these formulas in place.
    Last edited by AliGW; 03-15-2017 at 09:45 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. macro to copy rows to a new worksheet based on criteria
    By hiswillbedun in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-19-2015, 07:26 PM
  2. [SOLVED] Copy data from one worksheet to another worksheet based on criteria
    By kunal Shah in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-15-2015, 05:13 AM
  3. [SOLVED] Copy data from one worksheet to another worksheet based on criteria
    By kunal Shah in forum Excel General
    Replies: 2
    Last Post: 10-14-2015, 06:22 AM
  4. Macro for advance filter to create separate worksheet and workbook based on criteria
    By bossrockzz in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-18-2014, 02:36 PM
  5. Replies: 3
    Last Post: 05-26-2014, 02:21 AM
  6. Macro Button to copy data from one worksheet to second worksheet with criteria
    By vortex1fire in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-05-2013, 06:24 PM
  7. Macro to copy worksheet data to another worksheet based on criteria
    By excelvb in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-07-2011, 04:11 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