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

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

Win 7 Pro x64 SP1, Win 7 Ult x86 SP1
 
 

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

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

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

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 for2: ~ merge two spreadsheets with one sheet each into a new one based on m
Thread Forum
Cheat sheet: What you need to know about 802.11ac Network & Sharing
Excel 2013 Opening Size of Sheet Microsoft Office
How to Import custom label sheet for merge setup? Microsoft Office
Solved Two excel spreadsheets in Windows 7 Microsoft Office
Printing Excel-sheet Microsoft Office
Need Some help with Spreadsheets General Discussion
How do I get rid of white sheet behind desktop shortcut 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:03 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33