Question Locked
How to create excel macro that looksup value from changing cell contents?
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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!