Hi all,
I'm pretty efficient with excel and formulas but when it comes to VBA, I need serious guidance.
For the attached file, I'm trying to create a search function that will search column A (BIN) on the "CurrentBINs" sheet based on a six digit entry in cell B3 on the "Search" sheet and return information from the corresponding row across from the "BIN".
For example, searching for the BIN 403113 would populate Chase in the "Payee" field, PO Box 94014 in the "Address" field, Palatine in the "City" field, and so on, until ending with the "Notes" field.
Additionally, if there aren't any results, the phrase "No Results Found For BIN" should populate in the "Notes" field.
Lastly, most of the data won't have information listed in the Address 2 - Notes columns on the "CurrentBINs" sheet, so when searching, results should still display for the columns that do have data if the BIN can be found in column A. (I'm not sure if this is something that has to be included in the code or not, so I apologize for my misunderstanding if this isn't something to worry about.)
I appreciate any help that this community can give me as I have looked through about 100 pages of threads but couldn't find anything close enough to this that I could attempt to modify to tailor it to my specific needs.
Please let me know if anything else is required.
Bookmarks