Hi raghibakhter, thanks for the reply!
I think this is very close to what I am looking for, and it has sprung up an idea.
I am wondering if you could help me figure a few things out.
The code targets a table on the active sheet, is there a way to make it target a table on a separate sheet instead?
It also prompts the user for a keyword, is there a way to have it reference a cell with the keyword in it?
I've updated my file here to reflect what I am talking about, I'd like to see if there is a way for someone to use the
dropdown list in B1 to lookup the Keyword in the table located in Sheet2, then, change what has been returned
in the VLookup in B4 (Company Name in this instance).
My plan is to eventually do multiple lookups, with multiple "edit" buttons using this, and I think these foundations
will really help that out.
Bookmarks