Returning a Value dependant on a cell which could have different d

[Guest]

Hi Everyone,

I have two tables, the first lists letters from AA to ZZ in a lookup type
list and when on of these is selected, for example AB, the corresponding cell
in the second table (the equivalent AB) is populated with a Y.

Table A: Table B:

Type Site Controls Type Has Site Control
AA (various data) AA Y
AB " AB Y
DZ " DZ Y
LW " LW Y

So, as the data is selected in table A, the Y should be populated in table
B. I would appreciate the help on this as it would speed up my tasks
considerably.

Thanks in advance,

Remy

 

[Guest]

I do not know what you mean when you say the data is selected.
Do you mean the cell is selected with the cursor?
or that something is done with data from the first sheet.
The way to handle your needs depends on what is done in the selection.

 

[Guest]

Sorry, I didnt make it clear. The type ("AA", "AB", etc. will be held in a
drop-down list and both tables will be in the same worksheet.

 

[Guest]

I think you will need to have code to do this. I wouldrewrite the submittal
and resubmit it in the programming section.