search a range

I am having problems with trying to get this function to work. The Search function in the command seems to require a different format. Basically I am checking a long GL string, If $A2 contains 509 fill the cell with 509, If $A2 contains 511 fill the cell with 511, If $A2 contains 510 fill the...

Hello, I have this extensive two columns list, many of the items in the list are duplicated is there a way to find and delete the complete row of each one of the duplicate in both columns?

Hello, I am looking to derive a value based on a variable data set. I want take the date that is chosen and find that value in Column C then look to Column E's # that is chosen and give me the value from Column C that is that # (in this case 1) day prior to the Date I entered. Another kicker is...

First let me apologize if this has been answered before... I have searched this site & all across the web, and no formula found works for me... I hope someone here can help. I have two spreadsheets (in 2 workbooks). One SS is a listing of Store Samples, the other is a Price List of products...

I work for a non-profit community housing agency and created a workbook that has multiple tabs. One of the tabs is a spreadsheet that contains 22 columns (scope assumptions). On another tab I want to pull data from this large spreadsheet. There are usually at least a 100 rows, each room in...

Hi, I am quite new to VBA and have spent the better portion of the day reading forums so I thought I would just ask because I am stumped. I would like to have a macro that searches for a value in a specific cell in a column on another sheet. I simply want to select the first match in the...

I need a formula. Cell A19 contains 'JR', note that it will not always contain JR so I need the formula to use the contents of the cell no matter what it changes to. I am inserting a formula into cell E19 that is to search cells B3, B4, D6, D7, D8, D9, D10, D11, D12 & D13 for the text that is in...

Excel novice here, but I'll try to explain what I'm trying to do as clearly as possible. I have two columns of information, and I want to create a cell that will allow me to search the first column and then return the element that is in the next column, but in the same row. To explain further...

Morning all, I'm looking for help getting an idea from my head into a VBA code, I am very new to this!! I have a spreadsheet that I have a column (column E) that is populated with a unique number by a barcode reader. I am trying to get a command button to open a UserForm where the unique...

Hi all I have butchered the below code to run a simple search for a name in a single column and present a message box to confirm the result and highlight. The code although not pretty, works perfectly, so I would like to use the same code on another sheet. The other sheet is roughly the same...

Thank you for taking a look at my issue. It is a little long but I have tried to explain it as concisely as possible and will be happy to answer any questions. The included example data shows what i would like the end result to look like. I am using windows 7, Excel 2010.</SPAN> I am looking to...

Hi All I found some code online to run a basic value search on a column. I have modified it to suit my needs, but as I would like to add the function to "Try Again" if the returned result is not the correct one. I need this because the search is for names, and the sheet used by lots of people...

Hi All I am looking for a simple bit of code to seach column D for a name and select the next cell in column E. The data sould be validated so there are no duplicates, but the list will end up in excess of 1000 names so I would like a button at the top to prompt for a name, then auto...

Add Multiple Values Based on Criteria Search for the word "Clear" in the Task column. If the word "Clear" is found, go to Value column. Add all values starting from "Clear" down to the end of the list. If it is larger than 10, return the word "OK". Otherwise "Poor". If 20, return the word...