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.