Originally Posted by
davesexcel
You would have to supply additional details if this is in an open workbook, closed workbook.
To find the last string in column J and get the result from column P would be:
Thank you! So I got something that works:
I just brought in my data from the other workbook to sheet 2 to just test real quick, but I am intrigued on if this would be possible with a closed workbook? I think I would know how to do it by opening the other workbook, and then assigning it as a variable and then referring to that sheet for the search range.
But just curious for my Excel VBA knowledge on if it would be possible on a closed workbook as well.
Thanks for the help!
Bookmarks