Checking data in separate files

ScottA · #4 05-22-2014, 04:50 AM

Pardon me for jumping in. I noticed something in the OP that made me question the replies.

Quote:

I'm trying to create a macro that will compare data in two seperate files (spreadsheet A and B) and if it matches, return the data.

I can understand using the functions on two worksheets with in the same workbook. That makes sense.

If as I'm reading it - two workbooks - you would need to use VBA wouldn't you? If that is not the case would you mind pointing me toward how to do this? I would like to learn this as well.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Displaying multiple columns of shared data in separate mpp files	ggg	Project	1	01-08-2013 08:08 AM
Can I use the filter function to separate letters into separate files?	drhauser	Mail Merge	2	12-14-2011 02:18 PM
Spell checking and saving files	msword101	Word	1	10-08-2011 07:21 AM
Any easy way to separate a Word document into separate files?	SamHelm	Word	0	08-21-2010 05:29 AM
Checking for data corruption in Word	mart12	Word	0	12-18-2008 03:27 AM