Results 1 to 3 of 3

Match Copy & Paste Between 2 Wkbks Revised

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    11-15-2007
    Location
    England
    MS-Off Ver
    Office Pro 2003 / 2010
    Posts
    423

    Match Copy & Paste Between 2 Wkbks Revised

    Hi,

    In Column A of Wkbk1 starting in row 2 I have a list of codes.

    In Column A of Wkbk2 starting in row 5 I have a list of codes some of which match those of Wkbk1

    I need a macro that will run down the codes in Wkbk1, and if it finds a match in Wkbk 2 copy the values in specific cells W, K, M, P, BV, AJ, BC,AZ,AY,BF,BG,AW,BR,BU,CM,AM and paste to the cells C,D,E,F,G,I,K,L,M,N,O,P,Q,R,S,W of the row where that code is sitting in Wkbk1.


    Hope that makes sense.
    Last edited by timbo1957; 09-23-2011 at 10:31 AM.

Thread Information

Users Browsing this Thread

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

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