+ Reply to Thread
Results 1 to 2 of 2

Get data from one work book to another when a certain load number matches

  1. 11-18-2015, 06:29 AM #1
    boxy04
    boxy04 is offline
    Registered User
    Join Date
    11-18-2015
    Location
    Melbourne, Australia
    MS-Off Ver
    2010
    Posts
    1

    Get data from one work book to another when a certain load number matches

    So sheet 1 has a whole heap of information on it. I want to be able to type a load number in C7 on sheets 2. Which will match a load number in Column R in sheet 1. I then want information from certain columns that have that load number from sheet 1 copied onto sheet 2.
    Please see the attached file
    Thanks in advance
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-18-2015, 08:02 AM #2
    LeoTaxi
    LeoTaxi is offline
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Get data from one work book to another when a certain load number matches

    columnheaders are different


    Kind regards
    Leo
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA Code for populating cells from one Work Book A to another Work Book with condition
    By ray.kanata in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 06-22-2015, 03:46 PM
  2. assing a work number when name and last name matches in a cell .
    By blood4blood in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-13-2015, 04:51 AM
  3. Adding a row in the source work book won't add a row in the target work book
    By larremail in forum Excel General
    Replies: 2
    Last Post: 06-20-2012, 05:10 AM
  4. Extract data into a master work book by accessing various input work sheets/workbooks
    By kammariarun in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-08-2011, 05:10 PM
  5. To Much Data for 1 work book
    By bolosc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-23-2011, 01:07 PM
  6. Load form saved in one work book from another.
    By Francis Brown in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-11-2005, 11:10 AM
  7. Grouping Data to New Work Book
    By Paul Cooke in forum Excel General
    Replies: 0
    Last Post: 12-02-2005, 11:51 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1