help database excel

Hi all, I have been struggling with the following for a number of days now. I want to be able to retrieve the flights that can be connected with Y flight. Basically.. I have Flight nr AA0001 "Y" and based on a departure and arrival list and the minimum connecting time, i want to see which "X"...

Hi, I have search hi and low on the internet and this site but cant seem to get exactly what i am after. So hoping someone can point me in the right direction or assist. 1. Have an existing word doc which is quite busy with required information.Consists of 10 participants per enrollment sheet...

Hi, I have the following list of data:- <tbody> A B 7 750<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font: 10.0px Verdana}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 10.0px Verdana}table.t1 {border-collapse: collapse}td.td1 {border-style: solid...

Hello, I've found that an advanced filter is likely going to be my easiest option to filter multiple criteria and display the results. The Problem: The filter currently will not show results from data entered by a new user (me). I took over the sheet at row 3166 Data Sheet (some values after...

Hi, I need to add a part in a macro that will search in worsheet 2 for a value that is dinamic in workseet 1(search by column A and retrieve column B(email field), likevlookup) but will constantly be on column R and paste it in column AZ in worksheet 1, second part is to copy everything from...

Hi, I have created a search field and it works how i want it to but only when i input the exact data for the search, For example If I have "lions" in my dataset and he was 9 years old, I would have to search Lions but the age to the exact match for it to search. So what I want is to search the...

Hello Guru's I am in need of a Excel GURU that understands lego ...yep those little tiny bricks. If you also understand API that is a plus as thats the next step I need. I have found the people on this site are STELLAR!! Who is up for it>

Is there a way to take a spreadsheet that has 8 full pages of file numbers. Then have those numbers searched on a different spreadsheet that has 9000 pages used as a database. on the database spreadsheet the file numbers are listed on the G column. Then have all the matches highlighted on the...