Hi Folks,

I volunteer time to a non-profit organization that monitors
agricultural chemical applications. The recordkeeping is tedious. My
skills with VB are self-taught, and limited in scope. In an attempt
to speed up data entry, I've written some successful procedures.
However, now I'm stuck.

I'd like to enter a chemical name such as "Roundup" in cell G10, that
would trigger an automatic entry in cell H10 of "Monsanto", and
another auto-entry in cell I10 of "123-456", and yet another
auto-entry in J10 of "12 Hours". In the next row, cell G11 could be a
different chemical and require different info in the subsequent cells.

I've toyed with an IFTHEN procedure, and experimented with ToLeft to
jump to the next empty cell in the row. No luck. I think I'm in over
my head (or skill levels) and removed the entire module in
frustration.

Please help, and if you would, give explicit details about how it
works......I'm eager to learn.