search column

Hi Friends, I request your help here for a code to search for a column using column name and filter data using wildcards. ABC, PQR, and XYZ are part of the same team but no other column to identify teams and therefore they need to be searched at once from the given data. Below code was...

In an excel sheet I have two rows of data. I want to search the first row for the closest value of what the user inputs into the box and then do a weighted average of five values in the column next to the column I searched. The values are all in the column to the right of the searched column and...

Hello, I am trying to come up with some logic that will search for the text "Task Description" or "Method of Quoting" in column A, and if the cell in column B is blank, then it will display a warning message box. I expected it to be fairly easy but I cant seem to get there. Any thoughts?

Hello, I'm trying to asking Excel to search all values in a particular column for a specific number, and if that number is found, produce the result in the corresponding row in a separate column. I hope the formatting of the example below is clear enough to show the desired results. Thanks...

Hi, I am fairly comfortable with VBA, but definitely still consider myself a beginner. I need some help with coming up with VBA module to accomplish the following: I have labeled data columns in A1:F345. I need my users to be able to click on a box to launch the macro and enter a search word...

I am trying to find out how I can enter a number on a form and search a column "A1" for that number, if a match is found I would like to know the row number so I can pull data from that rown to form. If the number is not found I would like to know it was not found. This seems like it should...