I have 2 separate excel (2010) workbooks I’m working with and I would like to create a macro that, when run, will copy a variable value that is in cell J1 in workbook 1, and search workbook 2 for that value.
I’ve tried recording a macro that uses the search box but it doesn’t consider the variable value of J1, and always enters the value that the macro was initially recorded with.
Please Help!
