Results 1 to 13 of 13

Pulling data from source file into main file

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-21-2009
    Location
    England
    MS-Off Ver
    Excel 2016
    Posts
    710

    Pulling data from source file into main file

    Hi everyone, I have 2 identical spreadsheets in terms of layout. The source file which is where the data pulls from, and the main file - which is used as the working document.

    I am looking for some VBA code that will pull the rows of data from the source file into the main file where they don't already exists.

    The unique hooks here are column's B, H, I and N.


    So the Macro would sit in the main file, would go into the Source file and identify that lines 3,4,5 and 6 are not present in the main file and bring them across.

    However, there is one rule to factor in, if the date in column N is before 01/03/23 (1st March 2023) the line should be ignored. Any coding guru able to assists with this please as I think it will be quite simple for someone who knows how to approach this?

    Example file's attached and de-sensitised
    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. Replies: 0
    Last Post: 02-05-2020, 08:26 PM
  2. Replies: 2
    Last Post: 07-04-2019, 06:36 AM
  3. [SOLVED] Need Help Pulling Data from 1 file into another file using a reference file
    By MermaidNiki in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 02-07-2017, 03:52 AM
  4. Replies: 0
    Last Post: 05-28-2014, 02:45 AM
  5. Open 2nd file(CSV) from cell reference, copy columns to main file & close 2nd file
    By Langchop in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2013, 05:09 AM
  6. Pulling information to the main file from different files
    By shido in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-23-2011, 07:20 AM
  7. Replies: 1
    Last Post: 01-25-2007, 07:26 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