davejonesbkk Posted June 15, 2011 Share Posted June 15, 2011 Is there a function command for Excel where I can instruct it to scan through several separate excel files and tell me if any of the cells from these files have any matching data/content? For example, I have several excel files with thousands of websites listed in them, I want to be able to quickly and easily search all of these files to ensure that the same website/domain is never used more than once. Link to comment Share on other sites More sharing options...
PoorSucker Posted June 15, 2011 Share Posted June 15, 2011 No function. You can do it in VBA, visual basic for application that is embedded in Excel. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now