+ Reply to Thread
Results 1 to 3 of 3

Vba macro check and add records from working file to other workbooks

  1. #1
    Forum Contributor
    Join Date
    07-17-2011
    Location
    PH
    MS-Off Ver
    Excel 2007
    Posts
    183

    Vba macro check and add records from working file to other workbooks

    Hi Expert,

    I have a requierements to check, validate and add records from workbook to another workbook. Hop3 you can help me on my requirements.

    here is the concept or process. i have 3 workbooks

    1. working file workbook with macro codes that perform all the process.

    2. called incoming workbook that contains all incoming data given by group that handle the incoming materials its a fresh data. 3. status summary workbook this is coming from other group that contains records monitor if it is already transacted in the system. the status column that contains Done and Not yet.

    My requirements is

    1. how could i the check the data from workingfile workbook if that particular tracking#, model, total and labels is exist in Status summary workbook. if exist i have to validate if the status is "Not yet" have to change the status at working file workbook as INTRANSIT" while if the status is "Done" change it with "RECIEVED".

    2. the incoming data will be dump to working file workbook at the last empty row. before that i have to check if the tracking number is already exist to working file, if exist nothing will happen but if not yet exist i have to dump those tracking no and others details to working file workbook.

    3. the same process with number 1 to check the records if exist and validate the status. if done or not yet.

    Hoping the requirements is clear and well defined. Thank you very much.

    By the way, just created a sample data for these 3 workbook into one workbook under 3 worksheet as reference.

    attached is a sample data.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    07-17-2011
    Location
    PH
    MS-Off Ver
    Excel 2007
    Posts
    183

    Re: Vba macro check and add records from working file to other workbooks

    Anybody guys could help me on this requirements. so many thanks.

  3. #3
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Vba macro check and add records from working file to other workbooks

    Hi Jovillanueva,

    See the 3 files in the attached .zip file which contain:
    a. Working file (with macros)
    b. Incoming file
    c. Summary file

    This is a first attempt to meet your requirements. I changed your requirements slightly to fit what I thought you needed. To run the macro CLICK the yellow command button on Sheet1 of the Working file.

    I was unable to get data from the Incoming file for the following items that are in the Working File:
    a. ETA
    b. Status
    c. Month
    d. Year


    My solution to your problem is implemented as follows:
    a. Open all 3 files
    b. Create helper columns in each file containing concatenation of tracking#, model, total, labels

    c. Tracking Number Check - Working File vs Incoming File
    (1) If Tracking Number in Incoming File exists in Working File - DO NOTHING
    (2) If Tracking Number in Incoming File DOES NOT EXIST in Working File - Add to the last row of Working File.

    d. Check working file vs Status Summary:
    (1) tracking #
    (2) model
    (3) total
    (4) labels
    e. If items exist change Working File Status from "Not Yet" to "INTRANSIT".
    f. If items exist change Working File Status from "Done" to "RECEIVED".

    Please let me know what changes you need.

    Lewis
    Attached Files Attached Files

+ 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. Macro not working for other workbooks
    By kosherboy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-01-2014, 08:44 PM
  2. [SOLVED] Spell check macro not working :(
    By AdamJaffrey in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-03-2013, 05:52 PM
  3. Macro to check for file modification and display a pop-up or reload the client file.
    By Askander in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-02-2011, 09:26 AM
  4. Check subfolders for excel workbooks with a certain source file
    By rmpereira25 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-07-2011, 11:45 AM
  5. Replies: 3
    Last Post: 04-29-2009, 03:59 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