+ Reply to Thread
Results 1 to 1 of 1

Macro to find cell value in a column

  1. #1
    Registered User
    Join Date
    02-03-2014
    Location
    Los Angeles, California
    MS-Off Ver
    Excel 2010
    Posts
    23

    Macro to find cell value in a column

    I don't have much knowledge with VBA so I appreciate all help I can get.
    I'm trying to write a macro to do the following:
    1) Take cell A1 and copy adjacent cell B1 in new sheet.
    2) Then search cell B1 to find a match in column A.
    3) If there is a match, I want to copy that adjacent cell in B and into the new sheet.
    4) If there is no match, then leave as is from before and move onto the cell.
    5) Continue for the rest of the data.

    Here is an example of what i am trying to achieve
    This is in the first sheet:
    Column A Column B
    Car Saw
    Dew Jacket
    Pen Key
    Saw Screen
    Hand Shoe
    Jacket Window
    Screen Sock
    Saw Ride


    Now I want this in the next sheet:
    Column A Column B Column C Column D
    Car Saw Screen Sock
    Car Saw Ride
    Dew Jacket Window
    Pen Key
    Saw Screen Sock
    Saw Ride
    Hand Shoe
    Jacket Window
    Screen Sock

    I hope this helps and thank you for your help!

    I will attach what I am looking for.
    Attached Files Attached Files

+ 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. Macro to find cell value in column
    By wwballar42 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-27-2014, 06:58 PM
  2. [SOLVED] Macro to find the empty cell in a column and copy a adjacent row to another column.
    By naga in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-18-2013, 07:44 AM
  3. macro to find first blank cell in a column cut the value from left adjacent column
    By willykin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-01-2012, 09:23 AM
  4. Replies: 1
    Last Post: 03-02-2010, 01:23 PM
  5. how do find out the column of the active cell in a macro?
    By Neill Lee in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-20-2005, 05:06 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