I am looking to do a VBA for a Vlookup that can be used in multiple Workbooks that have different Data. I have a template that I am looking to use so it would be the same columns in both sheet 1 and 2. The VBA I have created works in the workbook I created it in but not any others.
Solved by T. F. in 25 mins