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: Can I compare 2 Excel spreadsheets cell by cell?

04 Feb 2015   #1
tomseeley

Win 7 home premium 64 bit
 
 
Can I compare 2 Excel spreadsheets cell by cell?

I have an Excel 2010 workbook comprising a simple organization membership list, consisting of names, addresses, etc., for nearly 2,000 members, grouped into 5 chapters' sheets, in a single Excel 2010 file. Every time I sit down to enter updates for any member, or add new members, etc., I always start by saving my most recent version of the workbook with the date I last updated it in the filename, and then when I finish my updates for the day, I save the current day's updated workbook with the current day's date in the filename, etc. So after a while, I've got quite a stack of versions of the same workbook, albeit with slightly different data in some of the cells, from version to version.

Near the end of the year, it'd be neat to be able to compare the beginning and end of year versions, cell by cell, to see what changed.

Ideally, I'd like to sort of "subtract" one workbook from the other, cell by cell, and display something in the results that shows cells that differ btwn workbooks and cells that don't.

Obviously, I could just print the two versions, and plow through them both, side by side. But they're nearly 2,000 rows deep, all things considered, and with all the data we compile for each member, each row goes up to column AT! That's a lotta data to compare visually cell by cell.

Is anything like what I'd like to do possible?

Thx.


My System SpecsSystem Spec
.
04 Feb 2015   #2
Berkey

Microsoft Windows 7 Professional 64-bit SP1
 
 

I think this might help if I read this correctly. I used this before to compare three lists I made a long time ago, then when I needed to update them I didn't want to sift through hundreds of entries.

Compare Two Lists in Excel - Easy Excel Tutorial

From MS https://support.microsoft.com/kb/213367

Also 4 Ways to Compare Data in Excel - wikiHow
My System SpecsSystem Spec
Reply

 Can I compare 2 Excel spreadsheets cell by cell?




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
6 Cell Vs 9 Cell Battery for Laptop?
Someone needs to get a new battery for a very old laptop they have. The battery doesn't work so they have to have it plugged all the time otherwise it wouldn't work. Laptop is 15.6 and sort of heavy but the thing is they never take the laptop outside the house. It will mainly be used on one floor...
Hardware & Devices
Excel cell
Office 2010/Excel I accidentally entered an email address into a cell and now I can't get rid of that format in that cell. No matter what I do, whenever I try to enter text into that cell it is always illuminated in blue and is underlined, just like email addresses are. How can I make this cell...
Microsoft Office
Excel 2010 Multiply cell
I am kinda stuck with this issue, basically what I want to do is multiply any number which is put in row H by 10 and put the value in the next cell in row I, how can I do this? Thanks
Microsoft Office
Excel: How can I insert the value of cell into ActiveX button caption?
Hi, I'm using Office 2007 and I have an Excel file that I have to update often. Therefore I will automate certain tasks using macros accessible by ActiveX Control command buttons. However, I would like for the captions to be relative to information found in certain cells; examples of a caption I...
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
Excel 2007 Home and Studentl: calculation results in blank cell
A strange thing is happening on one of my Excel spreadsheets. If I put a value in cell A and another in B and use cell C for the result of my calculation, cell C produces a blank. Cell C, however, does show what is input directly to it. Please! Why is that happening and what is the cure?
Microsoft Office


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:42.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App