+ Reply to Thread
Results 1 to 2 of 2

Auto fill fields in one spreadsheet using info from fields in another

  1. #1
    Registered User
    Join Date
    08-02-2018
    Location
    uk
    MS-Off Ver
    2016
    Posts
    3

    Auto fill fields in one spreadsheet using info from fields in another

    Hi

    I have one spreadsheet which lists the name of schemes and various project attributes and another spreadsheet which has the name of the schemes repeated several times as it involves different information. I need to add the info scheme info from spreadsheet 1 on to spreadsheet 2 but the info is on 1 line per scheme on spreadsheet 1 so needs to be duplicated on spreadsheet 2.

    Sorry, found this difficult to explain but have attached examples of what I mean if this helps. I know I can filter and drag across the information but this is going to more time than if I can just use a formula.

    Many thanks
    Attached Images Attached Images

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Auto fill fields in one spreadsheet using info from fields in another

    Looks like you should use VLOOKUP or INDEX/MATCH to insert the data.



    Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.

    Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

    Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. auto fill fields
    By ZoWiiEee in forum Excel General
    Replies: 2
    Last Post: 04-17-2012, 06:06 AM
  2. Auto Fill Fields
    By mbesspiata in forum Access Tables & Databases
    Replies: 0
    Last Post: 03-19-2010, 09:24 AM
  3. Auto fill fields
    By Eucarionte in forum Excel General
    Replies: 1
    Last Post: 07-24-2009, 05:32 PM
  4. Auto Fill in Fields
    By bmcnaugharcher in forum Excel General
    Replies: 0
    Last Post: 07-18-2007, 10:54 AM
  5. Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS!
    By PSSSD in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-08-2006, 04:35 PM
  6. Replies: 2
    Last Post: 01-31-2006, 10:45 PM
  7. Auto-Fill in List Fields?
    By coritsia in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-06-2005, 01:26 PM
  8. [SOLVED] Need pie chart with number of fields instead of info in fields
    By Lloyd Pratt in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-21-2005, 07:05 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