Macro that Matches up two different columns of data

Please Login or Register  to view this content.

But why?

VLookup function will do the job and much much faster...

Worked great thanks. I may have several different people using this spread sheet and I did not want one of them to easily change the formula.

Originally Posted by glide2131

I may have several different people using this spread sheet and I did not want one of them to easily change the formula.

I mean

Please Login or Register  to view this content.

Thats even better thanks. Also, some of the values in column A are based on formulas and the macro does not seem to be picking them up. In fact after I run it once the macro does not seem to work with that row ever again.
Do you know how to fix that part?

I can not replicate your problem here, so I need to see your file.

Ok, so maybe you can think of an easier way to do this. The numbers in column A represent a file folder. The numbers in column C represent a bunch of random documents that have been given naming conventions. I want the macro to match the document name in column C with the file name in column A along with its folder location that is in Column B.
The only problem is that the beginning of the naming convention is the same but the end is different. For example. all our naming conventions start with a series of numbers than a "." then the name of the document. IE: "000-00-000.BlankDocument.2014" So my idea was to list file numbers in column A of Sheet 2 and list the naming convention in cell B2 of sheet1 and then combine them using a formula. However, the macro would not find the file names in Column A unless I typed them in.
If that does not make sense let me know. I have attached a new workbook.
Thanks again for your help.

You have no match. Because your formula is adding a space at the end.
Change the formula to

Please Login or Register  to view this content.

I don't know how I missed that. You are great! Thanks again.

Sorry to bug you again. I had to make a change to this macro. I wanted to place a button on another sheet named "Input" and your code only works on the active sheet. Would you be able to show me how to convert it to a specific sheet?
Thanks a ton.

Change the sheet name

Please Login or Register  to view this content.

That did it. Thanks again