optimisemywebsite.co.uk

Posts Tagged ‘Excel’

Alirght, let me see if I can make this question clear…..in excel, I have created a search engine. I want to take collected data and run it through this search engine without manually entering it. In other words, in sheet 1, I have search fields that need inputs in A1, B1, and C1. After inputting data, the search engine spits out a result into D1. Now, I want to be able to input data into sheet 2 and get excel to take the information and transfer it into A1, B1, and C1 automatically and then I will have a link in sheet 2 of the D1 result.
So now, I can run my search a lot quicker. Does this make sense? Thanks everyone!

I will give this question a shot again, trying to make it a bit more clear.
In excel, I have created a Search Engine. It searches through a bunch of data and based on 3 inputs, it spits out a result.
In other words, I have the speed in MPH of a bunch of people based on where they were per second. If you input a time and speed into the search engine, it will tell you the person that was closest to this speed at the given time. So the result is the persons name and the inputs are the time and the reported MPH.
Now, suppose my search engine is in sheet one. In sheet 2, I will have bunch of reported data….a list of times and MPH of how fast I think they are going. I want to know who I thought I was looking at. Therefore, I need all my data from sheet 2 to go into my search engine in sheet 1. I will then get a reported name that I would like to appear next to my data in sheet 2.

What I want to do is use vb in excel to make a form that has a textbox, a button, and frame. I want the input into the text to match cell in column A (when i press the button it will commit the search function) and return the column B data next to the cell it matched in column A and post it in the frame? Basically, make a search engine and have column A be the data to search. How would i do this?