Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


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

30 Aug 2013   #1
winbroken

win 7
 
 
~ 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 System SpecsSystem Spec
.
30 Aug 2013   #2
DavidE

Multi-Boot W7_Pro_x64 W8.1_Pro_x64 W10_Pro_x64 +Linux_VMs +Chromium_VM
 
 

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 System SpecsSystem Spec
31 Aug 2013   #3
winbroken

win 7
 
 

*** 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 System SpecsSystem Spec
.

02 Sep 2013   #4
winbroken

win 7
 
 

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 System SpecsSystem Spec
02 Sep 2013   #5
winbroken

win 7
 
 

it would be type B on Excel Data Matching Merger 2.1 but that script doesn't seem to work on excel 2013
My System SpecsSystem Spec
Reply

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




Thread Tools




Similar help and support threads
Thread Forum
HOW can I Convert vista home premium spreadsheets on 7 Ultimate x64
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:
Microsoft Office
How to Import custom label sheet for merge setup?
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...
Microsoft Office
Two excel spreadsheets in Windows 7
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
Microsoft Office
Printing Excel-sheet
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...
Microsoft Office
Need Some help with Spreadsheets
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...
General Discussion


Our Sites

Site Links

About Us

Find 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 05:06.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App