search and list

Hi guys, need some help here. Basically every month, my company accounts dept will send me a long list of claims/expenses that have been made for the project I'm working on. I need to sort all these claims out into its respective category (flights, accommodation, food, etc.) The problem is...

Hi everyone, I'm currently tasked to handle a small project for a company I am interning at. I'm new to excel and so far my knowledge has been based off reading forums and guides online. I'm looking to create a macro that'll allow me to search through this Excel database through multiple...

Hello, I have a large list about 10K rows. This list will be updated constantly but I need a way to do it, when a new list arrives I need to add only the words that are not in the original. Any one has an idea how can I do this? The list has two columns but the search is only in the first...

Hello all, I am trying to have excel show me the sheet name of a workbook based off two criteria. what i am trying to do is get the formula or VBA to show me the sheet names for everything with a date between 1/1/2014 -12/31/2014 and value is less than 2,500. All the sheets are formatted the...

So I have a worksheet with data in 6 columns A-G and down to row 150 and I am wanting to be able to do a search to find specific text in any one of the columns. I like the functionality of the auto filter search but you can only do that in one column and I am wondering if there is a way to...

I am trying to do a search that is returning the incorrect result. Here is the data. Sheet1 <colgroup> <col style="WIDTH: 30px; FONT-WEIGHT: bold"> <col style="WIDTH: 164px"> <col style="WIDTH: 76px"></colgroup> <tbody> B C 2 Dog Cat A 3 Zebra House Car B 4 Mouse...

Never posted here before, so hoping for a good first experience. With some help I've put together some coding to create a search field (like on google) to go through a spreadsheet containing customer feedback. i can key in a specific word and if the word appears within the range, then the...

Hi all, I am building a data entry userform with searching function; however, I face a great problem on searching and edit function. I have 2 userform, the userform 1 contains a few text boxes and combo boxes and 2 listboxes. I want the 2 list boxes can show the result from two different...

Hello all, So I'm working with a big worksheet containing delays, these delays are all assigned a code based off of the reason for delay. I'm trying to add a search feature that searches my initial sheet "Raw Data" for all entries of the ata code and than displays them on a new sheet "Output"...

Hi I have a 2 Column excel file. 1st column is just the Serial Number in increments of 1. Every cell in 2nd column has Text ending with a square bracket, e.g. ] Sometimes a sentence ends with a number enclosed between two closing square brackets e.g. ]12] I am looking for help for a VBA Macro...

Hi All, I have a userform with a textbox (TbAdd6) and a cmd button. I have managed to search and list all the matches, in a new userform containing a listbox, using the cmd button and this works fine. However it will only find exact matches from the data entered in the textbox. How can work it...