+ Reply to Thread
Results 1 to 4 of 4

Updating from one Worksheet to another

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

    Updating from one Worksheet to another

    In my document I have 3 sheets. The first sheet is all the new information for a product the second sheet is all of the information currently in our system and the third sheet will be a combination of the two. What I am looking to do is to search the first two sheets and add/update any information on the third sheet from the combined first two. If anyone has any experience doing this, any help would be greatly appreciated.Example.xlsx

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

    Re: Updating from one Worksheet to another

    If anyone could help or has questions please ask.

  3. #3
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Updating from one Worksheet to another

    I see that you have tried using vlookup. Did you face any issues with it?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

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

    Re: Updating from one Worksheet to another

    No Issues with Vlookup. However what I am looking to do is essentially look through the first two sheets and update/add on the third. From what I have found out it will only add based off one sheet.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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