+ Reply to Thread
Results 1 to 3 of 3

Automatically collect Data from another WorkBook

  1. #1
    Forum Contributor
    Join Date
    05-12-2012
    Location
    India, Chennai
    MS-Off Ver
    Excel 2003
    Posts
    182

    Automatically collect Data from another WorkBook

    Dear Expert

    Please Help !!! I am posting this again due to no reply, Hoping my query will be taken for consideration.

    I have two workbook. I need to auto collect the data from WorkBook1 to WorkBook2 IF the conditions are True.
    Attached the two reference WorkBooks in detail.

    Thanks for your time and effort
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: Automatically collect Data from another WorkBook

    Hi

    you got other title same this one?
    Last edited by micope21; 05-20-2012 at 01:26 PM.
    To help you by my post? it would be nice to click on to say "Thank you".
    If you are happy with a solution to your problem?
    Click Thread Tools above your first post,
    select "Mark your thread as Solved".

  3. #3
    Forum Contributor
    Join Date
    02-12-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2007
    Posts
    275

    Re: Automatically collect Data from another WorkBook

    Hi Skhari

    There are some problems in your question.

    1.) Your sample data is not the correct data.

    2.) Why are all you data on separate sheets (Will work much better as a single sheet)

    3.) How many data will there be?

    Have a look at this file.
    WorkBook2.xlsm
    a few points to note
    a. I have only done April
    b. Workbook1 must be closed (the macro opens it, and the folder is not important)

    Did I understand your problem and how well did I answer your question?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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