Hi Trot,

If the depending cells are in a fixed column I would use
Vlookup

Assuming you have your Master table in sheet2 ,A1:B2 like:
A 15.000.000
B 10.000.000

Then put in I3, J3 and K3:
=vlookup($f3,sheet2!$a$1:$b$2,2,false)
If you then enter A or B in F3, the result will appear in
the other cells.

Copy this formula down to all the cells you need.

If this is not what you want, please post again

Wolf

-----Original Message-----
If anyone can help me on this one, it would be much
appreciated. I want
to be able to type a letter in a cell and have it
automatically execute
some action. More specifically, I have letter codes I
will be entering
into column F.

For example, I would like to be able to enter the
letter "B" into F2
and have excel place values of 10,000,000 in cells I2
and J2
automatically. Or another case would be entering the
letter "A" in F3
and have excel place values of 15,000,000 in I3, J3, and
K3.

The code "B" would always need the value placed in the 2
cells starting
3 columns to the right of where the code is input.
Likewise, "A" would
always need the associated value placed in the 3 cells
starting 3
columns to the right of the input cell and so on.

I already have tables of the codes and what values they
represent on
another worksheet. I just need to be able to take those
values and have
excel place them in the designated cells automatically
upon entering
the code.

I hope I explained what it is I wish to accomplish.
Thanks again.

Trot


---
Message posted from http://www.ExcelForum.com/

.