I have a very simple spreadsheet with values in columns A, B, and C. I have, quite unsuccessfully, been trying to write a macro to search column A for a value that is input via a text box and return the value of column B in the same row for each instance of the value input in the text box. The format of the returned values needs to be in a list format that I can copy and paste.
Any help would be greatly appreciated!
Thanks