search a range

Hi All, I have a file with a LOT of data, particularly names, so I wrote a quick search macro that opens and closes the columns based on the entry from the user so they don't have to scroll through thousands of columns. It works wonderfully, and is actually pretty quick for the amount of...

my work requires me to take a submitted document (created in excel) Sheet 1: Branch: Science Group/Level: AS02 City: Vancouver etc..... In sheet 2, all rows start with a process number (column A) and the information above is populated ex: column A...

Hi all, So I have three worksheets: 1) Original 2) Source 3) New. I want to create a macro that loops through a specific range in the Original workbook, searching for each string of characters within each cell of the Original range within a specific cell (say, B2) of each worksheet in the...

I have data sheet in which i want to put the condition to search the cell which have data in it, all other cells in a range are empty. I am talking about here is condition or formula not the filters Thanks

I have this code I've written out in VBA to search and basically I want it to search in column A for a textbox value and, if found, provide the information from columns b-j in the same row so if information is found in a17 I want it to tell me b17, c17, d17 etc all the way to j17 (for example)...

How do I find out if a cell I have selected is included(or not) in one of the numerous named ranges in my workbook? It would be nice to do this outside of coding. Ideally I would like to select a cell and have a list of named ranges that include that cell. Why.. because I have inherited a huge...

Hi I'm helping a colleague solve a time consuming problem by writing them a UDF. The UDF shown below takes a string, searches each cell in a range, and builds a comma separated list of all the cell values (in a correspoinding range) containing the search string. The result string is stored in...

I need a formula that will search sheet1 columnB for specific text from sheet 2 columns B through column AZ. If Match, return a the value from sheet2 columnA and place in sheet 1 columnC, second match to columnD, third to ColumnE, etc. The text in sheet 2 that I'm searching for can be found...

Hello all, I'm trying to update a masterfile spreadsheet which contains a whole load of employee names. In order to make it easier to navigate, I'd like to create a search bar (rather like that of google, where you type in the text box, click search, and it takes you to what you queried). I've...

Hello Gurus, I have a problem that I'm hoping I can get some assistance with: I have a spreadsheet with two tabs that need formatting applied to certain lines. In column A - if the word "Total" appears (It can be mixed with other characters), I need the line turned grey and the text bolded...

Hi, I need a code that, for instance will search across multiple sheets, each called a different letter of the alphabet, for a surname, and then return the value of the cell at the bottom of its column. I have tried looking at searching over multiple sheets, and returning the last value of a...

Hi Guys, I just wondered if anyone knew if it was possible for you to Put a Reference or Value Say " Wedding" into cell A1 on Sheet one and for it to return a PDF or Cell Range that you have named on another Sheet? but return it to a specific cell range say A2 to J80

Hi, I have a dropdown list in cell B11 in sheet1 where I can select values from column A in sheet2. Everything works okay, but I would like to have a quality routine that alerts me if the selected value in B11 exists more than once in column A in sheet2. That is, because this value is used...

Hello, I have a question that I hope someone can help me with. I have a workbook that contains a sheet called "Foundation Permits" that my company uses to track addresses of new building permits and whether or not we gained that address as a client. Sometimes we end up gaining projects that are...

Hello, I have to search a long list only column A if there is any word with an Uppercase letter following by the second in Lowercase. Difficult to explain.... Column.........................Column A.......................................B Doris Angel........................."" Ruper...

Hello I am using =IF(COUNTIF($A:$A, $F4)=0,"TRUE","NOT TRUE") to find same words. The problem is I need to find any word in the cell that is equal to the one in F4. Something like this: column A: car / cars Column F4 cars so the search is NOT TRUE. I need the formula to...

Hi all and a happy new year! I am looking for help with a basic user form that has: 1x Combo box. 1x List box I need it to pull data from 4 columns on Sheet 1. If the combo box selection states "Factory" then it needs to pull the stated data below from the matches to "Factory" in Column I...

Hi everyone! First timer on the boards, please don't bite I have a spreadsheet I'm using for "sign-in" function, using a barcode scanner. I'm not worried about that part, I have it setup and ready to go. However, I'd like to have a sheet I can use to have pop-up messages when specific users...

Hi, I am attempting to write a macro that checks a column for multiple criteria and if one is missing then sets cell 1 in the column to red. (It is for a roster to ensure all positions are filled, eg there is an "M", an "A", two "O"s, a "TS" or a "DS" and keep the first cell in that row red...

Is there a way to use a macro that when run will filter a data table based on a fill in the balk cell value? By fill in the blank I mean to reference a cell that's outside of the table, that when a user types in a number, say "R250", that the macro knows to use the input "R250" to filter a filed...