Searching for A row in excel by value and then saving a test result in a specific cell in that row

[eknudson]

I am trying to figure out a way to search withing a spreadsheet by an ID number, return data related that ID number, then save a test result in a specific cell. I have attached sample spreadhseet to look at. Basically when I enter the sample ID I want to be able to display the Batch date and Temperature, Run my test, then save the result in test result collumn and in the row corrosponding to the sample ID. The samples will not typically be tested in order and a typical list will have about 500 rows of data. Has anyone done something similar before or know of any examples that might get me started?

[aputman]

A .txt file is not a spreadsheet.  Are you wanting to save this information to an Excel spreadsheet first and then perform the task mentioned, or are you solely working from the txt file?

[eknudson]

Sorry here is the spreadsheet. 

[eknudson]

Forgot to mention. The data could start as a text or excel file whatever is easiest to work with for this application.

[Gregory]

You can try something like this (this will only work for text files, you want the Report Generation Toolkit for Excel files):

[Dennis_Knutson]

Or use a real database. You find the row with a SELECT and WHERE clause. Change the row with UPDATE.

[eknudson]

Thanks! I will start with these and see how it goes.

[aputman]

Here is how you could do it using Excel ActiveX.