+ Reply to Thread
Results 1 to 2 of 2

Updating Data one worksheet based on another

  1. #1
    Registered User
    Join Date
    05-25-2012
    Location
    Charlotte, North Carolina
    MS-Off Ver
    Excel 2010
    Posts
    7

    Exclamation Updating Data one worksheet based on another

    In the attached document I have 3 sheets. The first sheet is information regarding cars (includes tracking number, transmission type, engine, etc). The second sheet is pulled from the online data base and containt the same information plus additional information entered by the user. What I want to do is update the second sheet with the new information on the 1st sheet and add in any new fields.

    Right now, the best way that I have thought to do this is add in an addititional third sheet that uses a combination of VLOOKUP and IF statement/functions the pull between the first two sheets. However, this does not update any information that may be added.

    I was going to see if anyone could please take a look at this workbook and see if they have any solutions. (An array function might work or even a macro) Any help would be awesome and I would like to thank you in advance.

    Attached is an example document but still see the desired fields. Example.xlsx

  2. #2
    Registered User
    Join Date
    05-25-2012
    Location
    Charlotte, North Carolina
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Updating Data one worksheet based on another

    Any help would be great.

    Thanks

+ 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