Tech Support Guy banner
Status
Not open for further replies.

Comparing excels

698 views 2 replies 3 participants last post by  Keebellah 
#1 ·
Hi,
How can one compare two excel worksheets with multiple tabs, to check if each tab has same duplicate data? My basic purpose is to see if any changes in respective tabs have been made.
 
#2 ·
Seems you need to implement a database? That would track data entry it for you much easier than the macro/vb it would take to compare each sheet. I can't think of a simple way to do this. Open same spreadsheet in each table and read/compare line by line..maybe sort first.
 
Status
Not open for further replies.
You have insufficient privileges to reply here.
Top