Results 1 to 4 of 4

How to Conditionally Copy of Column from Another Workbook

Threaded View

  1. #1
    Registered User
    Join Date
    07-03-2016
    Location
    INDIA
    MS-Off Ver
    2013
    Posts
    38

    Question How to Conditionally Copy of Column from Another Workbook

    Hi,

    (1) I have sample workbook named "Database" as master database, in which I have 20 columns of data for 10 items (named A to J) with each item is having data in 2 adjacent columns
    (2) I have another sample workbook named my "MyWorkbook", in which I am randomly selecting some of the 10 items e.g. 5 items in Sheet1
    (3) I want to copy data of both columns pertaining to this randomly selected items from my source file (i.e. Database) and paste it to respective destination cell reference mentioned in "Column C" of my target file (i.e. MyWorkbook)

    For better understanding I am attaching both sample workbooks.. Can anyone help me with VBA code for this please....
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditionally copying from one workbook and paste results to another workbook -multiple
    By egchristensen in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-30-2015, 12:05 PM
  2. [SOLVED] Insert new column and conditionally copy and paste values
    By kriahnadas.oo7 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-28-2013, 10:07 AM
  3. Replies: 0
    Last Post: 07-24-2013, 01:09 PM
  4. Conditionally Copy/Paste Data from one Workbook to another
    By justin19 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-02-2013, 04:48 PM
  5. Search multiple workbook headers and copy column entries to another workbook
    By R3n3gad3-XtC in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-13-2012, 12:47 AM
  6. [SOLVED] Conditionally Copy Cells from Multiple Sheets and Paste in Another Workbook
    By Gos-C in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-07-2012, 09:22 AM
  7. Replies: 6
    Last Post: 09-27-2011, 02:11 PM

Tags for this Thread

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