Results 1 to 5 of 5

Search values and copy to specific sheet & cells

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-17-2011
    Location
    amsterdam, Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    189

    Search values and copy to specific sheet & cells

    Hello!

    I am trying to create a macro that searches for other a specific value in column C
    If value 'VS' has been found (in column C) the values of column C and D need to be copied to Sheet "VS". In column A and C
    If value 'LND' has been found (in column C) the values of column C and D need to be copied to Sheet "LND". In column A and C
    Hope somebody can help me, made an example file also with how the solution should look like. Hope somebody can help me!

    Thanks!!
    Attached Files Attached Files
    Last edited by keis386; 11-19-2013 at 11:54 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. HELP! Macro to Copy specific cells from one sheet to another based on specific criteria
    By atriscritti in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-11-2012, 11:05 AM
  2. Macro to search sheet for certain criteria and copy specific data to cell
    By ThaGonz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-02-2012, 12:34 PM
  3. Search specific column and then copy to new sheet
    By PowerZ in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-25-2010, 10:04 AM
  4. Search and mark specific values in cells
    By RollWeb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-16-2009, 06:09 PM
  5. Replies: 0
    Last Post: 11-19-2009, 09:20 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