Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

excel spreadsheet

Status
Not open for further replies.
240877

240877

IS-IT--Management
Aug 18, 2003
1
GB
How can you write a VB code to compare two excel spreadsheet. I want to see whether there has been any changes made to the status column in the spreadsheet. Thanks!!!!
 
Sort by date Sort by votes
You don't necessarily need do write a macro. Go to Tools->Track Changes->Highlight Changes....

You can set this up to highlight changes in any specific range or the entire workbook. If you have any questions on this, read the Help File, it explains a lot.

NOTE: This function automatically shares your workbook.

Hope this helps!



Peace! [peace]

Mike

Never say Never!!!
Nothing is impossible!!!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
1K
remeng
remeng
feipezi
  • Locked
  • Question
How to pull data from MS Access DB and place on an Excel spreadsheet with WHERE clause? 2
Replies
10
Views
535
feipezi
feipezi
huiettcm
  • Locked
  • Question
Excel UserForm Window 'Focus' Event Listener 1
Replies
14
Views
705
huiettcm
huiettcm
feipezi
  • Locked
  • Question
How to find a string from multiple Word files, which are listed on an Excel spreadsheet? 3
Replies
17
Views
692
Andrzejek
Andrzejek
remeng
  • Locked
  • Question
Run PowerShell Commands from Excel VBA
Replies
14
Views
3K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top