+ Reply to Thread
Results 1 to 2 of 2

Macro to copy cells from workbook,where column C is = "num1" AND Column D ="num2"

  1. #1
    Registered User
    Join Date
    11-18-2011
    Location
    New york
    MS-Off Ver
    Excel 2003/2010
    Posts
    11

    Macro to copy cells from workbook,where column C is = "num1" AND Column D ="num2"

    Hello I am not very familiar with VBA coding. I have a master workbook which I am populating data from a number of other slave workbooks. In my master workbook I have a column(C) for "x coordinates" and a column (D) for "y coordinates". In column (E) I have an "R", "L", "T", or "B". What I need to do is be able to select a slave workbook to pull data from, and then find which row in the slave has the exact numerical values and column "C" and "D" in the master and then copy data from that row into the master workbook. There are three cells that need to be copied from the corresponding row, but which cells get copied and where they get copied to depend on the master's column "E", wither it is R, L, T, or B. I should be able to handle the specifics but could use help coming up with a way structure the code and select a slave workbook.Master.PNGSlave.PNG

  2. #2
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: Macro to copy cells from workbook,where column C is = "num1" AND Column D ="num2"

    Here's a suggeston to start with. I haven't tested it at all, and I'm sure you'll have a lot of tweaking to do as well. Good luck!
    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 search for "NO" in a cell and copy all but "NO" to a different column! plz help
    By fredderf81 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-26-2013, 03:19 PM
  2. [SOLVED] If there is any text in column "A$" on "sheet1" then move cell to column "A$" on "sheet2"
    By ckgeary in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-27-2013, 08:28 PM
  3. Replies: 2
    Last Post: 06-06-2013, 12:45 PM
  4. Copy value from column "X" paste into Column "Y" - visible cells
    By kaseyleigh in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-22-2012, 05:46 AM
  5. How can i copy value from "HTMLText"(EMBED("Forms.HTML:Text","")),using Macro
    By andrewyang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2010, 12:47 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