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.
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.
You should rephrase your question so that others may understand what you are asking
Two Excel workbooks each with multiple Tabs
A worksheet only has one tab; BTW @draceplace has given you the answer too
Status
Not open for further replies.
You have insufficient privileges to reply here.
Related Threads
?
?
?
?
?
Tech Support Guy
9.9M posts
859.7K members
Since 1998
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!