Hi,
I would like to use a tabulation of hundreds of chemical names and corresponding properties as a 'database' on Sheet1. The 'database' would begin in row 10 of Sheet1 (named "DATABASE"). Column A of Sheet1 would contain an substance ID code (integer), column B would contain the alphanumeric name of the substance, Column C would have its molecular weight (single or variant), etc.
I want to be able to type in a shorter list (perhaps 10 or 20) of chemical names and proportions (adding up to 100 percent) in column B and column C, on Sheet2, beginning at row 15.
Then, I want use the names of the items in column B on Sheet2 in a loop search for the properties of those chemicals in the 'database' on Sheet1 and to copy the properties from the appropriate rows in the 'database' and 'pasted' into "columns F to whatever" in the rows on Sheet2.
In other words, I want to extract the properties for a subset of the database components and concentrate that information on Sheet2, so that I can do additional VBA things with the subset of information.
I prefer to use VBA and Excel to handle this, rather than to use C++ or Fortran, etc.
Help!
Bookmarks