Search and Display macro

[friedmandillon]

Let me start off by saying that I have not done any coding for almost ten years. Suffice it to say, I'm out of date.

Anyway, I need a macro that will search a certain column on a worksheet and display all the occurrences of that information. Ideally, a user would be able to select a column header as a criteria for search our of a dropdown menu then enter in the name or value they were looking for and it would come up For example: if I were to select "Author" out of a dropdown menu, then type "Lemmings" and click a button only the articles by Lemmings would show up.

[shg]

How about just using AutoFilter?

[friedmandillon]

AutoFilter does do exactly what I'm talking about but I need that same sort of function above the data. For some reason that is not satisfactory for the project I am working on.

[friedmandillon]

I have a spreadsheet where I have articles listed in one column and authors in several other columns. I am trying to create a macro that will scan each column for every instance of an author. For example sometimes they are the primary author (and thus listed first) and other times they might be a secondary author (and thus listed second to eighth).An AutoFilter only searches the one column but not the others. Any advice?