+ Reply to Thread
Results 1 to 1 of 1

Query Copy Data from one workbook to another workbook IF 2 x Criteria's match

  1. #1
    Registered User
    Join Date
    01-16-2014
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    8

    Query Copy Data from one workbook to another workbook IF 2 x Criteria's match

    Hi Experts,

    I'm currently using excel VBA to copy DATA from one WORKBOOK to another if 2 criteria's are met =

    Both workbooks are saved in one folder.

    Workbook 1 name - ExcelMints.xlsx
    Workbook 2 name - ExcelChoco.xlsx.

    I've been trying to get it to work for a while but no luck . What i'm trying to achieve is :

    Criteria 1 : If B:B in Sheet ExcelChoco is present within the range of B:B AND
    Criteria 2 : If E5:E10000 contains a value then copy cell value in "E" to cell E in ExcelMint.xlsx
    Criteria 3 : If Cell B="DARK-01" or "Power-01" leave blank/ignore

    Can someone please advise/help me with the following ?.

    Help would highly be appreciated.
    Last edited by Excel_Padwan; 02-19-2015 at 03:11 AM.

+ 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. Replies: 5
    Last Post: 01-22-2013, 01:33 AM
  2. copy data to new workbook & sort data into different categories if criteria match
    By natnauk16 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-07-2013, 03:53 AM
  3. [SOLVED] Copy specific data from one workbook to another workbook with certain criteria
    By marc5354 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-12-2012, 12:09 PM
  4. Copy specific data from one workbook to another workbook if certain criteria
    By excelvb in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-04-2011, 04:14 AM
  5. Copy specific data from one workbook to another workbook if certain criteria
    By ejschulte2001 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-12-2010, 05:58 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