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
 
 

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 Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Cheat sheet: What you need to know about 802.11ac
Cheat sheet: What you need to know about 802.11ac | TechRepublic
Network & Sharing
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
How do I get rid of white sheet behind desktop shortcut
Hi, Just that, if I make a desk top short cut say of a website, a white sheet with the top right corner folded is behind the icon, how do I ger rid of them?
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 15:21.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App