+ Reply to Thread
Results 1 to 3 of 3

Code to copy selected data based on critera in a table

  1. #1
    Forum Contributor
    Join Date
    09-03-2012
    Location
    Newcastle
    MS-Off Ver
    Excel 2010
    Posts
    132

    Code to copy selected data based on critera in a table

    Hi,

    So I have the following:

    Data in columns A:CL

    In Column A, the majority of data containes the data "DWPK".

    I need to copy any row that contains DWPK in column A and paste onto workbooks("Report 27 with Macros") on tab "Test".

    Thanks!

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Code to copy selected data based on critera in a table

    Can you attach the workbooks? This usually speeds up finding the exact solution.

    You can try to start with:
    Please Login or Register  to view this content.
    Last edited by Solus Rankin; 11-14-2013 at 12:57 PM.
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

  3. #3
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Code to copy selected data based on critera in a table

    Another option:

    Please Login or Register  to view this content.

+ 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. [SOLVED] Macro to copy rows based on a critera and copy the name of the column
    By dreddster in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-10-2013, 11:34 AM
  2. copy data from selected cells , in selected row and paste it to ms word table ?
    By aaashaaa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-06-2010, 03:25 PM
  3. VBA code for coping selected data to another sheet based on a criteria
    By BJ5352 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-14-2010, 02:16 AM
  4. Copy data from one column to another based off certin critera
    By rudolphe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-25-2009, 05:18 PM
  5. Copy a row based on mult critera
    By Engineers08 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-18-2007, 12:20 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