Hi,

I'm fairly new to VBA, so i'm having a bit of trouble with something.

I wanted there to be an input bar, which you can type in "abcxyz" and then search the range A1:A500 on Sheet2 where "abcxyz" might appear. Then, it'll return all the values in which the search term appears and paste them on Sheet1.

For example, if the value in cell A1 on Sheet2 is "Name abcxyz Blah Blah," it will take this value and put it on cell A1 on Sheet1 because the term "abcxyz" appears.

I'm almost certain there's a better way to do this, but the input bar is the only thing that i can currently think of.

Please advise!