Compare cell in one file to same cell in another file, continue macro only if cells match

[CherylC]

I have a master workbook that I use to accumulate responses. Each worksheet represents a different customer. The customer worksheets are then exported to separate files to gather information. Once customer data is gathered, it is then copied back into the master workbook. I have a macro on each worksheet within the master file that allows the user to first select a file to copy data from and then certain data is then copied back into the master workbook on the worksheet in which the macro was executed from. I want to add a piece to that macro that will check to make sure the customer number on the file that the user selects to copy from matches the customer number on the worksheet that they executed the macro from, i.e. it will copy the right customer's information onto the right customer's worksheet in the master workbook.

Here is my basic Open/Copy/Paste macro:

Please Login or Register  to view this content.

[TMS]

You could use something like:

Please Login or Register  to view this content.