+ Reply to Thread
Results 1 to 5 of 5

Merging Data from one sheet into another

  1. #1
    Registered User
    Join Date
    11-18-2022
    Location
    Illinois, USA
    MS-Off Ver
    365
    Posts
    2

    Question Merging Data from one sheet into another

    Hello! I am new to spreadsheets.

    I have 2 spreadsheets:

    Sheet #1 has several columns, the first is titled NUMBER, this sheet does not include a column titled DEPTCODE

    Sheet #2 has 2 columns, the first is also titled NUMBER that includes most of the same numbers as sheet #1 (a few may have been removed), the second column is titled DEPTCODE


    I need to get the data in the DEPTCODE column from sheet #2 into sheet #1 so that it is in the row of the matching number in the NUMBER column.*


    I have been trying to do this for 2 days in google sheets using Ablebits, but their addon does not work and their support is is not answering.*I cannot find any solution on Google as all of those are just trying to append stuff to the bottom. That is not what I am trying to do. I need to get this done right away.

    Can someone please help? I do not know how to give access to these sheets, so I cannot do that. Here are links to them.
    1drv.ms/x/s!Ajd-zt7m0APfrFkBmDm17gfDmaBo?e=qY6yWs
    1drv.ms/x/s!Ajd-zt7m0APfrFs7xiFflm-mbqgg?e=8P8xZd

    since I am new I cannot post links, which is kind of ridiculous since if a person is new, they probably need help.
    Attached Files Attached Files
    Last edited by tamiep; 11-18-2022 at 07:42 PM. Reason: add links

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: Merging Data from one sheet into another

    Power Query

    is that what you want?
    Attached Files Attached Files

  3. #3
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: Merging Data from one sheet into another

    what you want to do with these files on OneDrive? Just merge by NUMBER with the rest of columns from AG and DEPTCODE from Product Department ?

    EDIT:
    check these files
    From OneDrive
    you'll need change path in source step to yours
    Last edited by sandy666; 11-18-2022 at 09:21 PM.

  4. #4
    Registered User
    Join Date
    11-18-2022
    Location
    Illinois, USA
    MS-Off Ver
    365
    Posts
    2

    Re: Merging Data from one sheet into another

    Hello. Thank you so much for your help. This looks right, except there are 61 entries missing. The did not have any entries to match from the products page. Perhaps that is why they did not show. Could I as how you were able to do this?

  5. #5
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Merging Data from one sheet into another

    Quote Originally Posted by tamiep View Post
    Could I as how you were able to do this?
    which one? from post#2 or post#3 ?

+ 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. [SOLVED] Range - End if without block if error. merging sheet to sheet data transfer (help)
    By COURTTROOPER in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-18-2017, 07:09 PM
  2. [SOLVED] Merging three excel sheets data into one sheet
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-31-2016, 12:58 PM
  3. [SOLVED] Data Merging in 1 Sheet from 100 WB - New to the FORUM and Brand New to VBA
    By spiwere in forum Excel Programming / VBA / Macros
    Replies: 66
    Last Post: 01-19-2013, 02:39 PM
  4. Replies: 4
    Last Post: 01-12-2013, 04:12 AM
  5. Merging: displaying which sheet data comes from when merging sheets
    By zed commander in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-12-2012, 12:20 PM
  6. Merging data in rows and exporting to a new sheet
    By endoskeleton in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-19-2011, 10:53 AM
  7. Help with merging data from one sheet to several
    By mikejs2098 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-11-2011, 03:49 AM

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