Help with Setting up Excel 2003 to do queries

Hi, I am running excel 2003. I am trying to populate fields in one excel sheet with data from another excel sheet.
Here is the detailed information on exactly what I am looking to do.

1. I have a spreadsheet with about 16 columns. each column has a header, such as ID#, Notes, DATE, ETC. Each row under the header row is populated with information. The ID# is unique to the information in each row. This is my KEY so to speak.

2. Next I have a seperate spreadsheet made to look like a GUI, with boxes setup for each corresponding header in the above spreadsheet.

3. In the GUI spreadsheet I also have a "Query" box.

4. What I would like to do, is to be able to enter the unique ID# into the "Query" box, and have all the other fields populate with the corresponding information listed in the first spreadsheet.

I know this would be much easier to do with Access, but do to situational restrictions, excel is the only option.

I really appreciate any help anyone may have with this1
Thanks!

Could please upload a sample of your worksheet with all personal information removed? We would be able to assist you a little better.

Thanks!

Hi, sure I will attach an example.

Also, I will try to clarify a little better. I want to be able to use workbook2 as an entry form. When data is entered into one of the cells on the form, I would like it to update the corresponding field in workbook1. For example "WIDGET NUMBER" in the form on workbook 2 would automaticaly update "WIDGET NUMBER" field in workbook1. Once saved, I would like the fields in the form on workbook2 to be blank, and ready for the next set of data.

On a more complicated note, I would like to also have the "QUERY" section on workbook2 to function as just that. When I type, say a "BOX NUMBER" into the search field, I would like the results to appear in the results coulumns below.

So for example, if I searched for BOX ID 123qwe123, I may get 3 results of that BOX ID in the results field. Then, if I click on the BOX ID in the results field, all the corresponding data pulls from workbook1 and populates the fields in workbook2.

Again, THANKS for ANY HELP!

Can I ask why there are multiple boxes for widget numbers on Sheet2(Form) but on Sheet3(data) there is only one column for a Widget Number?

Each box contains a certain amount of widgets. So there can be multpile listings of the same box, but the widgets inside will be different. Its by designe, and I cannot change it, I just have to find a work around.
Thanks!

Okay got it finished just adding comments so you can understand what exactly I did and so I can re-understand what I did Upload in a few.

Thanks!

Hello there,

Attached is a workbook I believe accomplishes what you were attempting to do.
Let me know if you have any questions and if this works for you!

Thanks!

RVASQUEZ

@rvasquez

The OP asked for a 2003 file. He (or she) won't be able to open your file.

Thanks sorry about that, attached is the 2003 compatible version.