~ merge two spreadsheets with one sheet each into a new one based on m


  1. winbroken
    Posts : 23
    win 7
       New #1

    ~ merge two spreadsheets with one sheet each into a new one based on m


    hey im trying to do hobby project and i have this really big problem: im trying to merge two spreadsheets with one sheet each into a new one. they should be merged based on matching ids in column A1:A1000, so the outcome would not have duplicated ids.

    im assuming this is a common need but i couldn't find anything for excel 2013

    please advise. link to a good video guide would be helpful and good.
      My Computer
    Quote Quote

  3. DavidE
    Posts : 6,330
    Multi-Boot W7_Pro_x64 W8.1_Pro_x64 W10_Pro_x64 +Linux_VMs +Chromium_VM
       New #2

    Excel 2010 has a "Remove Duplicates" in the Ribbon Data tab.
    If Excel 2013 has this feature you should be able to copy the data from each sheet into a new single sheet.
    Then use the "Remove Duplicates".
      My Computer
    Quote Quote

  4. winbroken
    Posts : 23
    win 7
    Thread Starter
       New #3

    *** THANKS SO MUCH!!

    sorry i could i not explain this any better :/

    i found what i needed -- Excel 2010 Tutorial Consolidating Data Microsoft Training Lesson 19.1 - YouTube

    i needed to know what the word 'consolidate' in excel meant. this is by labels, so 'top row' and left column'

    this is for making a map!
      My Computer
    Quote Quote

  6. winbroken
    Posts : 23
    win 7
    Thread Starter
       New #4

    sadly i need to request for aid again as i realised far too late that 'consolidate, from what i understand, only does numerical data...

    advise please?
      My Computer
    Quote Quote

  7. winbroken
    Posts : 23
    win 7
    Thread Starter
       New #5

    it would be type B on Excel Data Matching Merger 2.1 but that script doesn't seem to work on excel 2013
      My Computer
    Quote Quote

 

  Related Discussions
On my old notebook "windows vista home premium" Ihad several spreadsheets. That notebook died but the files were saved to my newcomputer “Windows 7 Ultimate x64”. Nowthe spreadsheets are extremely garbled and unreadable. How can I open thosefiles on the new computer? :cry:
I guess that almost says it all, except when I attempted to clarify this in an edit, I suspect what I am trying to do is a document merge with fields I would need to create on the document that has the labels, one file has all the data and the other has a layout of six labels. I have a custom...
How do I bring up two (2) excel spreadsheets on my new 27" screen in Windows 7? I routinely do this with my Vista system, but can't bring up two spreadsheets at the same time with my Windows 7 OS mpeacock1231
Printing Excel-sheet
in Microsoft Office

Hi, I recently began learning Office 2010 and have an Excel specific question. The thing is, when I print an Excel-file I prepared the print is real tiny, almost unreadable as if the sheet should be divided into 6 or 7 pages rather than the 3 pages that I have somehow managed to get it down to. It...
Need Some help with Spreadsheets
in General Discussion

I apologize if I am in the wrong thread. I am unfamiliar with windows 7 and I am having trouble with spreadsheets. Shouldn't it be the same? I will try to give you as much detail as I can. I go to my email, Click on the link to open a file that supposed to open in Spreadsheets, After i do that I...
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

 © Designer Media Ltd
All times are GMT -5. The time now is 20:25.
Find Us